Hi,

You essentially want to do a SUMIF() across sheets which is not possible.
You can try the following:

1. Select cell D9 of sheet 1 and then while holding down the Shift key click
on sheet 30. This will group sheet 1 to sheet 30;
2. Now enter the formula =IF(B9=Summary!$B$9,Sheet1!C9,0);
3. Now while the sheets are grouped, delete sheet1! from the above formula;
4. Now in cell C9 of the summary sheet, you can use the formula
=SUM(Sheet1:Sheet30!D9)

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Rover" wrote in message
...
I am hoping some can help me...

Lets' say you have 30 sheets (tabs) in a workbook, and they are all the
formatted the same. There is also a summary sheet that calculates then
totals
from each sheet.

To sum the data from all the sheets, I use =(SUM('Sheet 1:Sheet
30'!$C$9)),
and it works fine.

However, how can I enhance the formula to add the cells where there are
pull-down menus (validations).

On the summary sheet I need the totals for X, Y and Z from cell C9 based
on
what is selected from the pull down menu in cell C9.

I appreciate the help, I spent lots of time on this today, and my brain
hurts.

Regards,
Fred