Thread: Count formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ryan L. Ryan L. is offline
external usenet poster
 
Posts: 1
Default Count formula

Hi All,

I have the following data:

Product Month
A 1
B 1
C 1
A 2
B 3
A 4
B 7
C 2
D 3
B 1
C 2
D 9

Could you please provide me the formula to count A, B, C, and D with below
conditions:
<2 months 2 - 6 months 6 months
A count= ? ? ?
B ? ? ?
C ? ? ?
D ? ? ?

Thanks & regards,