Forum Discussion
sum values in formula cells
I'm not sure whether this is what you were looking for. If it's not, please come back with a clearer description of what wasn't and isn't working.
I changed the formulas in the Report tab, in cells B4 and B5 so they now use the SUMIF formula, based on the Level associated with the raw data in the raw data tab.
Hi Mathetes,
Appreciate and thanks for your prompt feedback.
I had attached the worksheet for your advice on the formula linking from one sheet to another sheet within the same work book.
The " report sheet" is the desired output based on the "raw data sheet" compilation. I am trying not to do the traditional way of creating additional total row in the raw data sheet as in actual situation, there are multiple of different data to be added and reflected the answer to the "report sheet".
Thank you in advance for your advice.
I'm not sure whether this is what you were looking for. If it's not, please come back with a clearer description of what wasn't and isn't working.
I changed the formulas in the Report tab, in cells B4 and B5 so they now use the SUMIF formula, based on the Level associated with the raw data in the raw data tab.
- Hi Mathetes,
You solve my issue. Thanks.