| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
Actually, there's no need to coerce the last argument with a double
negative since Column A already contains numerical values... =SUMPRODUCT(--(B1:B100="Paid"),--(C1:C10=4811),A1:A100) Hope this helps! In article , "Alan" wrote: =SUMPRODUCT(--(B1:B100="Paid"),--(C1:C10=4045),--(A1:A100)) =SUMPRODUCT(--(B1:B100="Paid"),--(C1:C10=4811),--(A1:A100)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete Rows based on criteria in excel | Excel Discussion (Misc queries) | |||
| searching for specific criteria and then doing an action based on | Excel Discussion (Misc queries) | |||
| Count cells based on date range in another column | New Users to Excel | |||
| I have cells with diffent color fonts and need to total based on . | Excel Discussion (Misc queries) | |||
| Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions | |||
Threaded Mode
