Thread
:
Countif between two dates
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Countif between two dates
adapt to suit
=sumproduct((a2:a22b1)*(a2:a22<=b2))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"AOP" wrote in message
...
I have the following formular:
=IF($B5002="","",COUNTIF(MAIN!$B$10:$B$5000,"" &$B5002 & ""))
Column A is the date
Column B is the unit
How do I modify it to count between two dates that are in cells Sheet2 P3
and R3
Thank you
--
AOP
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett