array formula question

Topic

New Reply

I’m doing something wrong here. I would like to take two columns of data and then find the ratio of the two, based on a range of the first; e.g.

TDS Range
>=0 to =500 to =4000 to <10000

I set up an array formula to check the range and then divide named range TDS by named ranged SC, see attached worksheet. I get a result of 0.

And then I noticed that if I just divided TDS by SC and copied it down, I get different answers. This further suggests I don't know what I'm doing .

Suggestions on how to obtain the ratio would be appreciated.

Thanks.

Reply | Quote

Replies

TDS/SC returns an array of values – which do you want? I suspect you want SUM(TDS)/SUM(SC) so:

=SUMIFS(TDS,TDS,”>=”&E2,TDS,”=”&E2,TDS,”<="&F2)

Reply | Quote

suspicions confirmed!
I didn’t consider the sumifs command.
THANKS!

Reply | Quote