Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problems with sumproduct
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problems with sumproduct
OK, never mind. I spotted my own idiocy. I'd originally done it in 20°C steps and then decided to go in 10°C (with a formula for the steps = cell above plus 10). I'd changed the step value but forgot to change the upper value. So I ended up with 100 - 119.9999, 109.9999 - 129.9999 etc, so I was counting everything twice Sorry for wasting everyone's time (I had spent 1/2 an hour trying to figure it out before posting, then just after posting noticed what I'd done). Cheers, 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems with Sumproduct formulas | Excel Worksheet Functions | |||
SUMPRODUCT and format problems (2) | Excel Discussion (Misc queries) | |||
sumproduct causing memory errors? | Excel Worksheet Functions | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |