Thread: [Solved] count if statements
View Single Post
 
Old 05-14-2014, 08:12 AM
Alaska1 Alaska1 is offline Windows 7 64bit Office 2007
Competent Performer
 
Join Date: Nov 2011
Posts: 110
Alaska1 is on a distinguished road
Default 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")
Reply With Quote