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). |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct of two categories
Try this:
=SUMPRODUCT((TDL!P2:P700=AC4)*(TDL!P2:P700<=AE4)* (S&D!H2:H700="Gadget")) Does that help? *********** Regards, Ron XL2002, WinXP "CJ" wrote: 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). |
Reply |
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 |