Formula Needed to count data in a column based on certain data entered into another

WS Attached

On ‘SALES’ sheet E2 & E3 is where the formula needed to go.

Basically, when the letter “A” is selected on ‘SALES’ H6:H505, the letter “B” will be counted in F6:F505 and entered into E2

Same formula for E3 except it will count the letter “S” in F6:F505 based on the letter “A” entered in H6:H505

thanks

I entered it into E2 and it doesnt work. Says #VALUE!

ok, i did the array, however it is not counting the "B" & "S" based on the letter "A" in H6:H505
instead its just counting all the B's in E2 and all the S's in E3

I need it to only count those if the letter "A" is entered

Originally Posted by excelteam777

when the letter “A” is selected on ‘SALES’ H6:H505, the letter “B” will be counted in F6:F505 and entered into E2

Same formula for E3 except it will count the letter “S” in F6:F505 based on the letter “A” entered in H6:H505

thanks

Be more descriptive with your description

ok, in cell E2 of SALES is the formula needed. I need the letter "B" counted in 'SALES' H6:H505 when the letter "A" is entered into F6:F505

i also need a formula in E3 to count the letter "S" in 'SALES' H6:H505 when the letter "A" is entered into F6:F505

I thought thats what I wrote originally, sorry for any confusion

working fine, thank you so much

See post #7 and attachment

Thanks for rep and marked thread as solved