View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mondie Gonzales Mondie Gonzales is offline
external usenet poster
 
Posts: 2
Default using SUMPRODUCT

I am using SUMPRODUCT to count mulitple criteria in different columns. It has
worked up to this point, but I am now getting a VALUE!error and am not sure
why.

Here is the scenario: 2 columns
Month Type
Jan A
Jan B
Feb A
Feb B

I need to count the error types by month. My fomula looks like this:
=SUMPRODUCT(--(Month="Jan"),--(Type="A"))

Month and Type are named ranges. I have also tried replacing the criteria
with cell references.

Thank you.