sum count number of particular value in two columns

[technik]

Hi

I am trying to do a count of the number of "A"s in both Columns D and E

I can do a count of the number of matches in both columns but need to only do a count of how many "A"s there are in both ie. a particular value. I have seen some people use the SUM PRODUCT function for something similar e.g.

Please Login or Register  to view this content.

.

Can anyone help?

TIA

[davesexcel]

If the Item to count is in B1 then =CountIf() would work.

Please Login or Register  to view this content.

[Pete_UK]

Try this:

=COUNTIF(D1:D50,"*A*") + COUNTIF(E1:E50,"*A*")

Hope this helps.

Pete

[technik]

Hi

No sorry .. I need the count of "A"s in BOTH columns ie. number of matching pairs of "A".... not just the total number of As in both columns

Hope that makes sense

[Pete_UK]

Okay, try it this way:

=COUNTIFS(D1:D50,"*A*",E1:E50,"*A*")

Hope this helps.

Pete

[technik]

Thank you !

[Pete_UK]

Glad to help - thanks for the rep.

Pete