say if you want to sum cell range from a1:a4 in all the sheets and have
the result in c10.

you can use formulae in c10 as
=SUM(Sheet1!A1:C4)+SUM(Sheet2!a1:a4)+SUM(Sheet3!a1 :a4)+SUM(Sheet4!a1:a4)+.......


where Sheet1 , Sheet2 ..... are the sheetnames for which you want to
totalup values


--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271
View this thread: http://www.excelforum.com/showthread...hreadid=373982

Thank you for the reply, however, I don't think I conveyed my point
clearly....

I have a series of bidding sheets (7 sheets) in a workbook, I need the
total from each sheet to copy to one cell in my pricing sheet on our
contracts. The formula I have tried resembles this:

=sum('Contracts'A$9$,'Granite'C$7$................ .........) (just an
example)

and I've tried the IF command with no luck.

My frustration is adding up faster than my numbers will!! HELP ME,
PLEASE!!!!

Thanks for all the help!!! I look forward to a reply!!!!

Heather :)


--
HeatherCox
------------------------------------------------------------------------
HeatherCox's Profile: http://www.excelforum.com/member.php...o&userid=23722
View this thread: http://www.excelforum.com/showthread...hreadid=373982

Can you send your workbook to , for me to have
clear understaning of your problem

If you don't want to attach the original workbook, just attach the
similar workbook with dummy data.


--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271
View this thread: http://www.excelforum.com/showthread...hreadid=373982