Countif issue

		Microsoft Office Forums > Microsoft Excel > Excel
Countif issue

FAQ

Thread Tools

Display Modes

07-11-2012, 06:21 AM

Colin Legg Colin Legg is offline

Windows 7 32bit Countif issue

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Colin Legg will become famous soon enough

Hi,

Quote:

Next I want to count the number of "x"s per column that also have a name in column C but I cant get it to work quite right,

So here you have 2 conditions per row
Condition 1: Column C is not blank
AND
Condition 2: Column F is equal to "X"

COUNTIF() can't do that, but a new function in Excel 2007 called COUNTIFS() can.

=COUNTIFS(Input!C:C,"<>",Input!F:F,"X")

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
CountIF in R1C1 With Ampersand and Address Reference	MicronExcel	Excel	3	02-12-2012 06:49 PM
COUNTIF and Cell address problem	ColinC	Excel	3	12-24-2011 04:08 AM
Vlookup, offset, match & countif	jujuwillis	Excel	2	10-15-2011 11:06 AM
using a cell content as a string with COUNTIF	geoffm	Excel	1	08-16-2011 11:31 AM
Countif with 2 criteria	ibrahimaa	Excel	3	05-23-2011 11:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:15 PM.