COUNTIFS using date range for current quarter

**Mary Kelleher** · 08-29-2013, 11:00 AM

Good morning,

I am working on a summary sheet that includes multiple criteria including work completed for the current month, quarter and year (month, quarter and year in separate columns).

The following formula for the Quarter returns the correct value
=COUNTIFS('CP01'!$F:$F,"="&"E. PA/S. NJ/DE",'CP01'!$BP:$BP,">"&"6/30/13",'CP01'!$BP:$BP,"<"&"10/1/13")

But... I am trying to replace the dates with cell references. "6/30/13" would be replaced with a cell reference for the beginning of the quarter and "10/1/13" would be replaced with a cell reference for TODAY() to return a value of work completed to date not total for entire quarter. But this keeps returning a "0" value.

**Ron Coderre** · 08-29-2013, 11:06 AM

Something like this doesn't work?:

Formula:

Please Login or Register  to view this content.

Where: A1 contains the last date of the quarter before the one you're interested in

**Mary Kelleher** · 08-29-2013, 11:47 AM

Thanks Ron,
That's my issue, when I replace an actual date with a cell reference it returns a "0" value. The original formula I posted returns a value of 149, but when I use the following formula it returns a value of 0. (Cell KH1 = "6/31/2013")

=COUNTIFS('CP01'!$F:$F,"="&"E. PA/S. NJ/DE",'CP01'!$BO:$BO,">"&$KH$1,'CP01'!$BO:$BO,"<"&TODAY())

Mary