Sum

[RyanMaki]

I have a list of numbers that I'm trying to sum if they are within a date range.

I have on Sheet1 a start date and an end date. Start dates is in column B, End date is in column C. The series that I am trying to sum is in Column F. On Sheet 2, I have across row 1 dates beginning with 9/1/14 end ending in 12/31/15.

I am trying to have on Sheet2 a sum of all figures in Column F only if the date falls within the range.

As an example, for the 9/1/14 column on sheet2 should only sum items from sheet1 column F if they fall between the start date of 9/1/14 and hasn't ended before 9/1/14.

Sorry, I may not be explaining this well, and I'm sure if I did I'd be able to find the answer in the forum all ready.. Any other information I could provide that might allow you to help?

Thanks,

ryan

 

[ghrain22]

Look into the sumif(s) functions:
SUMIFS function - Excel
SUMIF - Excel

 

[Andrew Poulsom]

Does this help you (formula in h1 copied across:

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K	L
1		Start	End			Values		01/09/2014	02/09/2014	03/09/2014	04/09/2014	05/09/2014
2		01/09/2014	01/09/2014			10		100	90	120	90	50
3		01/09/2014	02/09/2014			20
4		01/09/2014	03/09/2014			30
5		01/09/2014	04/09/2014			40
6		03/09/2014	05/09/2014			50
Sheet1

Cell Formulas
Range	Formula
H2	=SUMIFS($F$2:$F$6,$B$2:$B$6,"<="&H1,$C$2:$C$6,">="&H1)

 

[RyanMaki]

Awesome. Thanks so much!