#1
|
|||
|
|||
Count If Formula
I need a little assistance on a fomula.
I have a tracking sheet that tracks steps in a process...by Column... So Column C is the first step...D is the second. E is third and so on and so on.......No cell in Column D or E will ever get completed until the previous Cell..completed. and it is always a date. I want a fomula that will count all of the Blank Cells in a column, but I only want it to count them if the Cell to the left has a Date in it. This will tell me how many items in this piece of the process yet need to be completed. I am able to get the count if....but the way I have it it counts all blanks in the column...... any help is appreciated. Thanks |
#2
|
||||
|
||||
Hi,
This formula will return a count where cells in column C have a date and cells in column D are blank: Code:
=COUNTIFS(C:C,">0",D:D,"=") |
#3
|
|||
|
|||
thanks Colin
that appears to be close...but as I run this out a few columns.....it is still calculating...this runs the same sequence out to comumn N. but it appears to me that if the first column has a date in it...it is still counting this as my main requirement to check for blanks in the cell to the right. Do I need to add something to say that if Column to is 0> and not blank? |
#4
|
||||
|
||||
Hi,
Please can you attach a workbook with a small (!) data sample and explain what results you want to see? |
#5
|
|||
|
|||
Here is a sample
The row at the top is to count the blanks....and I tried to modify so the numbers should change but if there is a date in the column...and a blank to the right...that should be counted. if there is no date in a column...and a blank to the right...it should not be counted. Column C appears correct to me. |
#6
|
|||
|
|||
Hi
Please find herewith a solution. The issue is because after the first formula you were creating a circular reference in the other columns. By inserting an extra column between each of your columns and putting the formula in each blank column avoids the circular reference problem. I am sure Colin will come up with a more efficient solution. Hope this helps. Tony (OTPM) |
#7
|
|||
|
|||
yeah, that does work....kinda
is that just becuase the formulas are side by side...or is it the actual columns of data? |
#8
|
|||
|
|||
Hi
Here is a better version. It will calculate rows from row 3 to row 1000, you can chnage this to suit. The issue was the calculation was working on the same cell that contained the formula hence the circular reference. Hope this helps. Tony (OTPM) |
#9
|
|||
|
|||
oh dang
that made it look all but to easy |
#10
|
|||
|
|||
was wondering. on a larger but similar sheet. I have tracking by regions of the Country....NW, SW, E, W etc...
any suggestions on how to have this be broken down.....say Column A has the regions and I want to have do the formula above...if A = SW This would be used to create a table to break down the # of items received by region... Thanks |
#11
|
|||
|
|||
Hi
Can you post a sample of your spreadsheet and we will try and help you. Tony (OTPM) |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word count question | Wuffybrother | Word | 3 | 03-22-2019 03:40 AM |
Count in Excel | zanat0s | Excel | 3 | 06-09-2011 10:53 AM |
Don't count hidden slides | Lu_Argentina | PowerPoint | 0 | 10-12-2010 02:12 PM |
How to Count from Different Cells? | Shahzad | Excel | 3 | 06-26-2010 01:06 AM |
Don't count 0 in a chart | Rmaisone | Excel | 0 | 08-21-2006 12:26 PM |