Count >0 Cells Based on Date Criteria

**kmcbriarty** · 03-25-2013, 01:42 PM

I am trying to Count the number of cells in a range where by a specific date from another cell.

(see attached JPG)

I am trying to count cells from column G that have a value where the date from column C is equal to (lets say) 2/17/13.

I have been trying to get this for hours...with help from web searches...and have only been able to get a formula that gives me a count that does not take into account the date I specify.

**Harribone** · 03-25-2013, 02:09 PM

Best to have a cell where you can enter the date to search for (below example uses A1 for this) and then another cell which does the counting.

=COUNTIFS(C:C,A1,G:G,"<>"&0)

This assumes that blank cell in your example are 0, you may need to change to =COUNTIFS(C:C,A1,G:G,"").

**kmcbriarty** · 03-25-2013, 02:16 PM

What you have is half way there Harribone.

When I plug it in the formula filters only the dates (based on the A1 value) but it is only counting the number of time the date occurs not the number of times that there is a value in the G Column...

**Harribone** · 03-25-2013, 02:28 PM

Can you upload a sheet with mock data please to see where its going wrong.

**Kevin UK** · 03-25-2013, 02:38 PM

Hi kmcbriarty

Try: =COUNTIFS(C:C,"17/02/2013",G:G,">0")

**kmcbriarty** · 03-25-2013, 05:03 PM

Kevin, your got it!

I just swapped out the "17/02/2013" with a reference to the cell I have the date in and...presto! it worked perfectly!

Thanks!

Like your name too, Kevin. Great people are named Kevin...kmcbriarty aka Kevin McBriarty...we rock!
...and I totally agree...Merged cells ARE the work of the devil!