How do I put a date range in the criteria of a countif formula?
Try one of these:
Use cells to hold your date range:
A1 = 10/1/2006
B1 = 10/31/2006
=COUNTIF(B4:B19,"="&A1)-COUNTIF(B4:B19,""&B1)
Or, with the dates hardcoded:
=COUNTIF(B4:B19,"=10/1/2006")-COUNTIF(B4:B19,"10/31/2006")
Format the cell as GENERAL or NUMBER
Biff
"hlpmelrn" wrote in message
...
=COUNTIF('Local Annual Sales'!B4:B19,"=38991") this works to show all
months creater then Oct 2006 how do I limit it to =38991 <=39022
Oct
31, 2006?????
|