Selecting Data between 2 dates-Excel

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
 
F

Frank Kabel

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)
 

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

Similar Threads

Creating a Chart on form from selected data in query. 0
Need Help with a VBA subroutine 0
Publisher is filling blank lines with data 2
Calculation Between 2 Dates 11
Dsum and Dmax with structured references 1
Hlookup/Vlookup with duplicate datas 0
export data by selecting date range 5
all cells in 2 workbooks have automaticlly changed to date format 1

Top