Sum in a date range

[PierceallOR]

I have a spreadsheet with flow rate data and am trying to sum flow rate by a date range.

The date is in column B in a month/date/year format. The numbers I am trying to sum are in column F. I would like to sum data that falls between 3/21/1978 and 6\22\1978. I cannot figure out what function ar series of functions I need to use. Any help?

 

[T. Valko]

I have a spreadsheet with flow rate data and am trying to sum flow rate by a date range.

The date is in column B in a month/date/year format. The numbers I am trying to sum are in column F. I would like to sum data that falls between 3/21/1978 and 6\22\1978. I cannot figure out what function ar series of functions I need to use. Any help?

What version of Excel are you using?

 

[Peter_SSs]

Welcome to the MrExcel board!

You cannot display images stored on your local machine. If you want to show a small screen shot ..

My signature block below contains 3 methods for posting small screen shots. Test them in the Test Here forum. That way, if something goes wrong, you won’t be messing up a main forum.

 

[PierceallOR]

I am using Excel 2010

 

[T. Valko]

I am using Excel 2010

Use cells to hold the date criteria:

• H2 = lower date boundary = 3/21/1978
• I2 = upper date boundary = 6/22/1978

Then:

=SUMIFS(F2:F100,B2:B100,">="&H2,B2:B100,"<="&I2)

Adjust the ranges to suit.

 

[PierceallOR]

Thank you Valco, that formula worked perfectly. It is similar to the formulas I was trying, except for the reference to cells for the dates. I kept attempting to manually enter the date range in the formula and Excel did not like that at all. Putting the date into a cell and then referencing it must be the best way to go. Thanks again

 

[T. Valko]

Thank you Valco, that formula worked perfectly. It is similar to the formulas I was trying, except for the reference to cells for the dates. I kept attempting to manually enter the date range in the formula and Excel did not like that at all. Putting the date into a cell and then referencing it must be the best way to go. Thanks again

Using cells to hold ALL of the criteria is the best way to go.

However, if for some reason you didn't want to do that then you can include the dates like this:

=SUMIFS(F2:F100,B2:B100,">="&DATE(1978,3,21),B2:B100,"<="&DATE(1978,6,22))