| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SUMPRODUCT - small correction required
I am facing small problem in the following formula.
=SUMPRODUCT(-(FE!$A$2:$A$65000=A7),-(FE!$B$2:$B$65000=B7),-(FE!$C$2:$C$65000="BSE"),FE!$E$2:$E$65000) The problem is I am always getting a -ve value whereas the actual value is +ve. If I try to change any of the "-" (minus) sign in above formula, it returns zero. Please help. Regards, Madiya |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ISERROR,SMALL,INDEX, MATCH, SMALL?? | Excel Discussion (Misc queries) | |||
| Small runtime error - advice required | Excel Programming | |||
| Excel VBA expert required! Small to medium job. | Excel Programming | |||
| Sumproduct Help Required | Excel Discussion (Misc queries) | |||
| dYNAMIC Array declaration, a small correction in my last thread! | Excel Programming | |||
Threaded Mode
