B
babycody
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.
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.