I'm having a bit of difficulty with sumproduct. I'm using it to work out
the amount of time something is spending in a given temperature bracket.
The data I have is a long list of temperatures taken at 30 second
intervals. What I've done is have two values (e.g. 120 & 139.9999) and
doing sumproduct using those.

So if the temperature values are in A1 - A100 and in B1 I've got 120
and in C1 I've got 139.999 the formula would be:

sumproduct((A1:A100B1)*(A1:A100<C1))

The problem is that it seems to be counting double: in one case I've
got 120 data points and it's counting 240 in total.



Is there anything I'm obviously doing wrong or is there an easy way
around this short of simply dividing it by two?

Thanks in advance for any help.

Rob


--
Rob_T
------------------------------------------------------------------------
Rob_T's Profile: http://www.excelforum.com/member.php...fo&userid=4952
View this thread: http://www.excelforum.com/showthread...hreadid=555513