Selecting Data between 2 dates-Excel

  • Thread starter Thread starter Glenn
  • Start date Start date
G

Glenn

Hi
I am making a Cash Position Report sheet wherein it will
gather data from the other related sheets. On this
report, I will specify "from:" and "to" dates and then it
will sum the data for these dates.

I tried the "if statement" but no success yet. Did it also
with "sumif" and still no progress.

Regards

Glenn
 
Hi
if your dates are stored in column A and your values in column B and
C1/D1 hold your from/to dates try
=SUMPRODUCT((A1:A1000>=C1)*(A1:A1000<=D1),B1:B1000)
 
Back
Top