COUNTIF Question

[cvehcnt]

I would like a formula that will count how many times a number appears in one column if a specific number or letter also appears in another column.

For example:

If Column A contains "A", "B", "C", "D" and Column D contains "11", "12", "13", "14". I want another cell to produce the sum of how many times "11" appears in Column D when the corresponding line in column A also has a "B".

Thanks

[rylo]

Hi

Assuming that A1:A4 has the values A, B, C, D and
B1:B4 has the values 11,12,13,14 then try

=SUMPRODUCT(--(A1:A4="B"),--(B1:B4=11))

Note that this will return 0 (as there are no A:11 matches. But if you adjust the formula to be
=SUMPRODUCT(--(A1:A4="A"),--(B1:B4=11)) it will return 1.

HTH

rylo