I am trying to add two countif statements together. I need to set the criteria for column H for Real Estate and then add countif for Column M for Promote.

If I use the statement below it is adding the both columns together.



=COUNTIFS('2014'!$H:$H,"Real Estate")+COUNTIFS('2014'!$M:$M,"Promote")

Alaska, my first reaction is "but he said he wants to add the two COUNTIFs together, and he told it to add the two COUNTIFs together, and it's adding the two COUNTIFs together—so what's the problem?"

This formula will produce the number of "Real Estate"s in column H plus the number of "Promote"s in column M. Since you're not happy with it, I'm guessing what you want must be the number of lines that have both values—{AND}, not {OR}.

If so, I've never used it but I think what you want is this:And only now I notice you actually did use COUNTIFS, not COUNTIF; you just used two of them.