Hi,

Sumproduct works like an array entered type formula but it doesn't need to
be array entered. I'm glad that worked and thanks for the feedback.

Mike

"PFAA" wrote:

Thanks. The first one worked!

So I don't need to use an array? Why do all the instructions I found about
multiple conditions tell me to use an array formula?

Thanks,
PFAA



"Mike H" wrote:

Hi,

It's the quotes, try this

=SUMPRODUCT((A2:A22=1188)*(B2:B22="Feb"))

and if Feb is a correctly formatted date try this
=SUMPRODUCT((A2:A22=1188)*(MONTH(B2:B22)=2))


Putting the number in quotes makes it a text string.

Mike


"PFAA" wrote:

I am trying to count based on multiple conditions. Here is a sample of my
table and the formula.

{=SUMPRODUCT((A2:A22="1188")*(B2:B22="Feb"))}

A B
1188 Feb
1188 Apr
1213 May
1188 May
1259 Mar
1188 Mar
0994 Jun
1188 Jun
0994 Jul
1188 Jun
0993 May
1188 Jun
1188 Feb

It returns a value of "0". Please help.

Thanks,
PFAA