Count based on letter designations and dates

On the attached example have two worksheets within one file, MASTER and INFO.

In INFO-B3, I need to count the number of times that MASTER-column [I] shows a value under 10000, MASTER-column [H] shows dates in 2006, MASTER-column [K] shows the letter "A".

In INFO-B4, I need to count the same information with the exception of MASTER-column [I] showing values between 10000-24999. The same for B5 and B6, with B6 showing values over 50000.

THEN, I need INFO-B11 thru B14 to show the same information but only when "AJB" appears in MASTER-column [G]

Thank you very much for your help. You folks are amazing.

Hi

B3: =SUMPRODUCT(--(MASTER!I1:I30<10000),--(YEAR(MASTER!H1:H30)=2006),--(MASTER!K1:K30="A"))
B4: =SUMPRODUCT(--(MASTER!I1:I30>=10000),--(MASTER!I1:I30<25000),--(YEAR(MASTER!H1:H30)=2006),--(MASTER!K1:K30="A"))
B5: =SUMPRODUCT(--(MASTER!I1:I30>=25000),--(MASTER!I1:I30<50000),--(YEAR(MASTER!H1:H30)=2006),--(MASTER!K1:K30="A"))
B6: =SUMPRODUCT(--(MASTER!I1:I30>=50000),--(YEAR(MASTER!H1:H30)=2006),--(MASTER!K1:K30="A"))

See how you go using the above approach to complete the formulas for B11:B14.

rylo

It seems to be working. Now to tackle B11:B14.

Thanks for your help!