COUNT INBETWEEN A DATE RANGE

  • Thread starter Thread starter Dave
  • Start date Start date
let's say your criteria in C1: early date, D1: latest date
date in column A, and number in column B

=SUMPRODUCT((A1:A100>=C1)*(A1:A100<=D1)*(B1:B100<>""))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top