Count the number of records that fall between two dates
I am working with a database column B is the date and column C is a numerical value representing deliveries.
I need to find the amount of people who had "1" delivery between the two dates.
So far I have, =SUMIFS(C:C,B:B,">="&H1,B:B,"<="&H2)
=COUNTIF(C:C,"1")
If I could combine the two it would solve my question
">="&H1 is the start date and "<="&H2 is the end date.
Right now it sums all the numbers between the two dates. I need to sum all the people with "1" in column C not just everything.
I have attached the document that I am working on.
Thank You
Attachment | Size |
---|---|
sum-between-2-dates.xls | 30 KB |
My solution
Hello,
Use this formula:
= COUNTIFS(B:B, ">=" & H1, B:B, "<=" & H2, C:C, "1")
Best regards.