Thread: sumproduct?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JR
 
Posts: n/a
Default 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