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