View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PFAA PFAA is offline
external usenet poster
 
Posts: 9
Default SUMPRODUCT question

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