count if statements
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")
|