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.