Formula for two seperate COUNTIF columns?

[Pezgordo]

I have a spreadsheet where Column F is labeled H(ome) / A(way) and Column G is labeled W(in) / L(oss). I have the COUNTIF formula to count the numbers of H/A in Column F or W/L in Column G. What I would like to know is how do I count the number of H's (in Columns F) that are W's (in column G), etc (H's that are L's, A's that are W's and A's that are L's)?

Thank you.

Tim

 

[CWatts]

Try using =COUNTIFS as that will let you specify multiple criteria.

 

[Jonmo1]

If you don't have XL2007 or higher, then you'll need sumproduct

=SUMPRODUCT(--(F1:F100="H"),--(G1:G100="W"))


Hope that helps

 

[Pezgordo]

Thank you very much. Both formulas worked perfect.