Worksheet references another tab in formula

[Bonita]

Worksheet contains Tabs: report and one for each month.
In the report tab Cell A2 contains the 3 letter month.
Cell a2 is named "month".
Formula in cell A4 needs to be the total of widgets for
the month in cell A2.
How do you reference the month in cell A2 in a formula to
bring the totals from that tab to the report cell A4,ie.
the formula in A4 changes to whatever month is in A2?
A1 A2 A3 A4
Month= JUL Total= =sumif(Monthtab!
A2:A10,"Widgets",Monthtab!B2:B10)

Thanks....

 

[Jason Morin]

Try:

=SUMIF(INDIRECT("'"&A2&"'!A2:A10"),"Widgets",INDIRECT
("'"&A2&"'!B2:B10"))

HTH
Jason
Atlanta, GA

 

[Bonita]

Thanks a million!!!!!!

-----Original Message-----
Try:

=SUMIF(INDIRECT("'"&A2&"'!A2:A10"),"Widgets",INDIRECT
("'"&A2&"'!B2:B10"))

HTH
Jason
Atlanta, GA

.