work sheet help with formula entry.

[leoj823]

=SUMIF(January!$C$2:$C$35,"agis bonus",January!$D$2:$D$35)+SUMIF(January!$H$2:$H35,"agis bonus",January!$I$2:$I$35)

The above formula was given to me in a previous post and it works perfectly. However, I want to know if there is an easier way to do the entry on my spread sheet, in that, I have 58 different "agis bonus"entries and I need to enter under each month, so it means changing the month and "data". I'm a novice on excel so I hope I'm explaining my self right.

Leo

 

[sheetspread]

The condition can be a cell reference instead of hard coded text. You can change the monthly sheet names in the formula dynamically with indirect.

 

[leoj823]

The condition can be a cell reference instead of hard coded text. You can change the monthly sheet names in the formula dynamically with indirect.

Could you give me an example with the formula I submitted with my question. I'm not sure I understand your answer.

Leo

 

[sheetspread]

Excel 2010
	A	B
1	3
2	7	x
3	8
4	6	x
5	5
January

Excel 2010
	A	B
1	2	x
2	2
3	6	x
4	1
5	8	x
6	3	x
October

Excel 2010
	A	B	C
1	x	January	13
Sheet1

Cell Formulas
Range	Formula
C1	=SUMIF(INDIRECT(B1&"!b1:b10"),A1,INDIRECT(B1&"!a1:a10"))

(change January to October and see what happens)

 

[leoj823]

Thank you for your time and help, I hope I can figure this our. It is so refreshing to see people helping others. Thanks again and God Bless.

Leo