Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT
Hi There,
Can anyone tell me why I am getting #Value! error with the following formula; =SUMPRODUCT(--(DATASHEET!$B$70:$B$300=C87),-(DATASHEET!$B$70:$B$3003<""),(DATASHEET!$E$70:$E$ 300)) -- CK |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT
all ranges must be of the same size. Can't have:
$B$70:$B$3003 get rid of that second 3. "ColleenK" wrote: Hi There, Can anyone tell me why I am getting #Value! error with the following formula; =SUMPRODUCT(--(DATASHEET!$B$70:$B$300=C87),-(DATASHEET!$B$70:$B$3003<""),(DATASHEET!$E$70:$E$ 300)) -- CK |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT
oh, and add another - to the second criterion.
"ColleenK" wrote: Hi There, Can anyone tell me why I am getting #Value! error with the following formula; =SUMPRODUCT(--(DATASHEET!$B$70:$B$300=C87),-(DATASHEET!$B$70:$B$3003<""),(DATASHEET!$E$70:$E$ 300)) -- CK |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT
Thank you so much, that fixed it!
-- CK "Sean Timmons" wrote: oh, and add another - to the second criterion. "ColleenK" wrote: Hi There, Can anyone tell me why I am getting #Value! error with the following formula; =SUMPRODUCT(--(DATASHEET!$B$70:$B$300=C87),-(DATASHEET!$B$70:$B$3003<""),(DATASHEET!$E$70:$E$ 300)) -- CK |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT
You were most of the way there already. :-)
"ColleenK" wrote: Thank you so much, that fixed it! -- CK "Sean Timmons" wrote: oh, and add another - to the second criterion. "ColleenK" wrote: Hi There, Can anyone tell me why I am getting #Value! error with the following formula; =SUMPRODUCT(--(DATASHEET!$B$70:$B$300=C87),-(DATASHEET!$B$70:$B$3003<""),(DATASHEET!$E$70:$E$ 300)) -- CK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
Sumproduct | Excel Discussion (Misc queries) | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
Sumproduct | Excel Worksheet Functions | |||
sumproduct help | Excel Worksheet Functions |