count if statements

		Microsoft Office Forums > Microsoft Excel > Excel
count if statements

FAQ

Thread Tools

Display Modes

05-14-2014, 08:12 AM

Alaska1

Windows 7 64bit count if statements

Office 2007

Competent Performer

Join Date: Nov 2011

Posts: 110

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")

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Multiple If statements,	Jamal NUMAN	Excel	16	11-15-2022 11:59 PM
If Statements in a form	Sammie0Sue	Word VBA	4	03-12-2014 01:16 AM
Multiple If statements	bremen22	Excel	2	10-15-2013 06:37 AM
showing results of If statements in a mail merge	m&co	Mail Merge	3	01-06-2012 07:27 PM
IF statements that shifts to right.	kent	Excel	0	01-19-2006 02:23 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:55 PM.