Count Blank Cells Within Date Range

[Coucher]

Trying to count the number of blank cells within a date range.

For example...

B3:B2500 could either have data or be blank.

C3:C2500 has a calendar date, for example 04/01/2011.

D3:D14 has the first day of each month, for example, 01/01/2011, 02/01/2011, 03/01/2011, etc

F3:F14 has the last day of each month, for example, 01/31/2011, 02/28/2011, 03/31/2011, etc

So, I want to count the cells in B3:B2500, if blank, and if between D3 to F3, or D4 to F4, so on & so on.

I've toyed around with COUNTBLANK, COUNTIF, & SUMPRODUCT formatting each different ways but can't seem to get to work.

Any insight or assistance is appreciated in advance.

Thanks!

 

[Peter_SSs]

Your first post quoted post #5 which was referring to the post #2 suggestion. That formula counts blank cells in column A within the date range

Now you appear to be using the post #3 suggestion. That formula counts non-blank cells within the date range.

Which result do you want?

In any case, if you are getting a #VALUE! error then one likely cause is that column A contains one or more #VALUE! errors.