Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct accross multiple sheets | Excel Discussion (Misc queries) | |||
added line won't update accross sheets | Excel Discussion (Misc queries) | |||
Summing across multiple sheets with a twist | Excel Worksheet Functions | |||
Summing same cell/cells from multiple sheets | Excel Worksheet Functions | |||
Summing Sheets - SUMIF ? | Excel Worksheet Functions |