Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-11-2012, 06:21 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Countif issue Windows 7 32bit Countif issue Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

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")
Reply With Quote
Reply



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
Countif issue Vlookup, offset, match & countif jujuwillis Excel 2 10-15-2011 11:06 AM
Countif issue using a cell content as a string with COUNTIF geoffm Excel 1 08-16-2011 11:31 AM
Countif issue 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 11:01 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft