| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
There's no need to use -- if you're going to multiply the arrays before
you pass the result to SUMPRODUCT. See http://www.mcgimpsey.com/excel/doubleneg.html In article , <Andy B wrote: I reckon SUMPRODUCT is what you need. Something like =SUMPRODUCT(--(A2:A1000="DO")*--(B2:B1000="RD11")) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNT NON-BLANK CELLS WITH REFERENCE TO ANOTHER COLUMN | Excel Worksheet Functions | |||
| Count cells based on date range in another column | New Users to Excel | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
| Count of items using multiple criteria | Excel Worksheet Functions | |||
| SUMIF multiple criteria in 1 range | Excel Worksheet Functions | |||
Hybrid Mode
