I am trying to use the > with a date and a range of cells with a count range.

=IF(f7:f11>7/31/08,COUNT(b7:b11),"") I am getting a value error. What I am
wanting my end result to show is if the dates within f7 to f11 are < 7/31/08
count how many invoices I have with an August date that are in the range of
B7:B11.

Should I use a between function?

Any help would be appreciated.

Look at the COUNTIF function

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Count if dates fall in certain range" <Count if dates fall in certain
(E-Mail Removed)> wrote in message
news:1F5ADBB5-D27B-410F-A770-(E-Mail Removed)...
>I am trying to use the > with a date and a range of cells with a count
>range.
>
> =IF(f7:f11>7/31/08,COUNT(b7:b11),"") I am getting a value error. What I
> am
> wanting my end result to show is if the dates within f7 to f11 are <
> 7/31/08
> count how many invoices I have with an August date that are in the range
> of
> B7:B11.
>
> Should I use a between function?
>
> Any help would be appreciated.

On Aug 26, 3:26 pm, "Don Guillett" <dguille...@austin.rr.com> wrote:
> Look at the COUNTIF function

And also...

You can't enter a date like that in a formula. The best way is to put
your limit date in a cell somewhere and reference it. Or you can use
DATE or DATEVALUE to put the date into the formula.