Add Up Rows dependant on cells

[lotsbg]

I have a problem that I would most appeciate getting answered. Any help would be greatly appreaciated.

As shown on the attached picture, I have various rows and dates up the top. In cells Basically in Cells C2 and C3 (not shown ) I have the start and end date.

Basically I was a column (Column T) that will sum the row if the numbers fall within the start and end date. So for example, if the start date was Apr-06 and the end Date was Jun-O6, then cell T9 would equal 7124.97 + 5540.70+3663.43. And would automatically change when you change the start and finish dates in cells C2 C3.

Any help would be greatly appreciated. Thanks!

 

[Andrew Poulsom]

Try eg:

=SUMPRODUCT(--(MONTH($L$5:$S$5)>=MONTH($C$2)),--(MONTH($L$5:$S$5)<=MONTH($C$3)),$L9:$S9)

Expand the ranges to suit, but make sure they all have the same number of columns.

 

[lotsbg]

Man you are a legend. Thanks heaps! Problem solved

 

[Peter_SSs]

lotsbg

To show your sheet on the borad, I suggest that you use the provided HTML Maker in future. To do so, see the link at the bottom of this page to Colo's HTML Maker. Also read the ‘Sticky’ titled: 'HTML Maker FAQ (How to show your sheet on the board)' which is at the top of this ‘Excel Questions’ forum. Test it out in the ‘Test Here’ forum which is found in the ‘MrExcel Message Board Forum Index’ before trying to use it in this forum.

Another approach to your current question would be as shown below. I have compressed the data to show it more easily on the board and have put my result in cell M3. The formula is:
=SUMIF(E1:K1,">="&C2,E3:K3)-SUMIF(E1:K1,">"&C3,E3:K3)

Once again, you would have to adjust ranges in the formula to suit your data.

Mr Excel.xls
	B	C	D	E	F	G	H	I	J	K	L	M
1				Feb-06	Mar-06	Apr-06	May-06	Jun-06	Jul-06	Aug-06
2	Start	Apr-06
3	End	Jun-06		1	2	3	4	5	6	7		12
4
Sheet1