#1
|
|||
|
|||
Sum raw data & cell containing a subtotal
I have a sheet tab that is using subtotals. On another sheet tab, I have raw data. Is there a way to sum a subtotal cell and a range of data? It's not working for me. It would be nice to be able to put both sheet tabs on one sheet, but I'm not sure if that could work.
Please see attached. I'm trying to sum C33 (in the first tab) plus B4:B7 (in the second tab) and place the result in B8 (in the second tab) for starters. Your help is greatly appreciated. Thank you, Karen |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Want to get the cell value on the bases of dropdown select. Want to copy the data from cell | Puneet Singh | Excel Programming | 0 | 02-08-2022 11:04 AM |
How to copy data to a specific cell by clicking on source cell? | LearnerExcel | Excel | 3 | 08-25-2021 04:46 AM |
Move the data at bottom cell to right side of the cell | kcyag91 | Excel | 1 | 01-28-2016 12:28 AM |
Data validation,force cell to be filed with number if respective cell is not empty | nicholes | Excel Programming | 0 | 08-01-2015 09:08 AM |
Each subtotal signature require only at last page for each subtotal. | aligahk06 | Excel | 0 | 05-07-2010 11:07 PM |