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.

Are the named ranges the same size i.e. number of rows? If not, this will
result in a VALUE! error.

My limited testing worked OK using named ranges.

HTH

"Mondie Gonzales" wrote:

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.

That was it. Thank you so much!

"Toppers" wrote:

Are the named ranges the same size i.e. number of rows? If not, this will
result in a VALUE! error.

My limited testing worked OK using named ranges.

HTH

"Mondie Gonzales" wrote:

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.