Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct?
Hi,
I would like to ask for help with a formula. On sheet one I will dump a report. On sheet two I would like to tally the totals of specific classifications for a specific date. Example I use this formula =COUNTIF(CS_Ticket_Dump!C:C,A1) for this result: Billing Issue 282 But if I wanted the same result only as it relates to a specific date how would I write this? Is it a sumproduct? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct?
JR wrote: Hi, I would like to ask for help with a formula. On sheet one I will dump a report. On sheet two I would like to tally the totals of specific classifications for a specific date. Example I use this formula =COUNTIF(CS_Ticket_Dump!C:C,A1) for this result: Billing Issue 282 But if I wanted the same result only as it relates to a specific date how would I write this? Is it a sumproduct? Thanks =SUMPRODUCT(--(ClassificationRange=Classification),--(DateRange=Date)) where Classification is a cell housing a classification of interest and Date a cell housing a date of interest. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct | Excel Worksheet Functions | |||
sumproduct causing memory errors? | Excel Worksheet Functions | |||
Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |