Thread
:
Count range of data
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
Count range of data
Look at the COUNTIF function
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Count if dates fall in certain range" <Count if dates fall in certain
wrote in message
...
I am trying to use the with a date and a range of cells with a count
range.
=IF(f7:f117/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.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett