|
|
#1
02-04-2015, 12:24 PM
|
|||
|
|||
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. 
|
|
#2
02-04-2015, 01:02 PM
|
||||
|
||||
|
Have a look at the COUNTIFS or the SUMPRODUCT function
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
#4
02-05-2015, 01:20 AM
|
||||
|
||||
|
Please find an example attached.
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
#6
02-05-2015, 07:55 PM
|
|||
|
|||
|
I have one more I have been working on. I want to count the blanks in a document. My worksheet is a table. I am able to count the number of blanks in the table but I want narrow it to specific cell.
=COUNTBLANK(Table2) I want to be able to count the blanks in the table and column d and as I added data it continues to count the blanks.
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Multiple If statements,
|
Jamal NUMAN | Excel | 16 | 11-15-2022 11:59 PM |
|
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 |
|
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 |
Windows 7 64bit 
Office 2007
Linear Mode
