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