Summing accross sheets
 

OK here goes. I am trying to use a formula from "Excel 2002 Formulas" by
John Walkenbach on pg. 207 for those that have it. The formula is
summing based on text in a cell. =SUMIF(Office,"=Oregon",Amount) Where
Office is the header of Column B, Oregon is a text value in Column B,
and Amount is the header for Column C. I would like to change the
formula somehow so that I am getting the sum of "Oregon" from accross
several sheets. Then perhaps I can actually create a pivot table from
that. Thanks for your time and any help you can give me.


--
babycody
------------------------------------------------------------------------
babycody's Profile: http://www.excelforum.com/member.php...o&userid=13120
View this thread: http://www.excelforum.com/showthread...hreadid=466651

See:

http://www.mrexcel.com/board2/viewtopic.php?t=123314

for a formula approach.

babycody wrote:
OK here goes. I am trying to use a formula from "Excel 2002 Formulas" by
John Walkenbach on pg. 207 for those that have it. The formula is
summing based on text in a cell. =SUMIF(Office,"=Oregon",Amount) Where
Office is the header of Column B, Oregon is a text value in Column B,
and Amount is the header for Column C. I would like to change the
formula somehow so that I am getting the sum of "Oregon" from accross
several sheets. Then perhaps I can actually create a pivot table from
that. Thanks for your time and any help you can give me.

Thanks Aladin. I'll give that a try.


--
babycody
------------------------------------------------------------------------
babycody's Profile: http://www.excelforum.com/member.php...o&userid=13120
View this thread: http://www.excelforum.com/showthread...hreadid=466651