I'm not getting anything in the Y-T-D column which should be a Grand Total of
that specific line item in cell h2 on each of the monthly tabs.
--
Regards ~ tates


"Pecoflyer" wrote:


In you summary sheet enter "=sum(" (no quotes)
Select the cell that should be summed ( in the summary sheet)
Then click on the tab of the first sheet to sum
While pressing the shift button select the last sheet's tab
Type the closing parenthesis in your formula

Should look like =SUM(Sheet1:Sheet12!G12)


--
Pecoflyer

Cheers -
*_Membership_is_free_* & allows file upload -faster and better answers
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=43854