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:
Code:
=COUNTIFS('2014'!$H:$H,"Real Estate",'2014'!$M:$M,"Promote")
And only now I notice you actually did use COUNTIFS, not COUNTIF; you just used two of them.