| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct of two categories
I have a sumproduct to count items within a given date range:
=SUMPRODUCT(--(((TDL!P2:P700<=AE4)*TDL!P2:P700)=AC4)) but I need narrow this even further to count only items that match "Gadget" in another range of entries. .....and (S&D!H2:H700="Gadget") I keep getting errors (#N/A). |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Switching Subcategories into Categories and Vice Versa | Excel Worksheet Functions | |||
| SumProduct Woe's | Excel Discussion (Misc queries) | |||
| Multiple charts in ChartSpace; problems with double Categories | Charts and Charting in Excel | |||
| Sumproduct function not working | Excel Worksheet Functions | |||
| adding two sumproduct formulas together | Excel Worksheet Functions | |||
Threaded Mode
