Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-04-2015, 12:24 PM
Alaska1 Alaska1 is offline Countif statements Windows 7 64bit Countif statements Office 2007
Competent Performer
Countif statements
 
Join Date: Nov 2011
Posts: 110
Alaska1 is on a distinguished road
Default Countif statements

I am using the countif statement to count how many customers have a yes in column h and j. So if there is a yes in both the fields I want the countif statement to count it. What is the best way to do this formula?



Example
Customer1 Yes in H Yes in I
Customer 2 Yes in I (so the statement would not count this one because it is not both columns.

Eventually when I figure out the formula and I am going to want to add third column J.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Countif statements Multiple If statements, Jamal NUMAN Excel 16 11-15-2022 11:59 PM
Countif statements Using IF statements stuwoolf Excel 2 01-10-2015 01:58 PM
getting IF and OR to work for 3 IF statements nero6014 Excel 3 09-16-2014 07:28 AM
Countif statements count if statements Alaska1 Excel 1 05-14-2014 08:21 AM
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 09:08 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