SUMIF & Date Ranges

D

D Maine

Hi there...

I need to select several records from an Excel table based
upon a date range (ie. Jan 1 - Jan 31, 2000), and add up
the dollar values for the selected records. I know to use
the SUMIF function, but I can't figure out how to show the
date range as the criteria in the formula.

Any help would be greatly appreciated.

=SUMIF('I:\PROJECT\[2000KER.XLS]!Sheet 1'A1:A3265,DATEVALUE
("1/1/2000"):DATEVALUE("12/31/2000"),H1:H3265)

Thanks,
D.
 

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

SUMIF between 2 dates 1
Use TODAY() function as the criteria in a SUMIF formula 1
How format SUMIF formula for matching date range and column value? 4
Using multiple IF statements 1
Formula help needed please 2
Multiple Columns in Sum Range using SUMIFS 1
VLOOKUP or SUMIF for Multiple Criteria 2
sumif issues 1

Top