P
PFAA
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
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