| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
SUMPRODUCT Problem
Can Someone tell me what is wrong with this formula.
I want to Sum All "B" products that fall betwene the acctounts 01010001-3907000 & 01010001-3907000 that is why I am trying ="01010001-3907*" =SUMPRODUCT((Actual!$D$2:$D$10000="B")*(Actual!$F$ 2:$F$10000="01010001-3907*")*(Actual!$I$2:$I$10000)) For some reason the total i am coming up with is the total for "B" only |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Baffling formula problem | Excel Discussion (Misc queries) | |||
| Sumproduct ... Empty Cells vs Spaces? | Excel Discussion (Misc queries) | |||
| Hyperlink to word document problem | Links and Linking in Excel | |||
| Paper Tray selection Problem, | Excel Discussion (Misc queries) | |||
| File is locked for Editing by user problem | Excel Discussion (Misc queries) | |||
Threaded Mode
