| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Curious about SUMPRODUCT
Given the following array:
1024 20 100 30 600 20 700 10 800 10 Is there a COUNTIF equivalent to the following formula? =SUMPRODUCT(--(A4:A8200),--(A4:A8/B4:B8=30)) I am just starting to appreciate the power of SUMPRODUCT, so I want to try and understand limitations of it as well as replacement functions. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct ... Empty Cells vs Spaces? | Excel Discussion (Misc queries) | |||
| Sumproduct function not working | Excel Worksheet Functions | |||
| adding two sumproduct formulas together | Excel Worksheet Functions | |||
| Sumproduct in Excel Spreadsheet to read Access db table | Excel Worksheet Functions | |||
| SUMPRODUCT using offset from ROW if X marks the spot | Excel Worksheet Functions | |||
Threaded Mode
