I have a Sharepoint list that is an import of an Excel File. My work area has three divisions. I have each location of each division reporting a number. I want to summarize each division and then have a total for all three divisions.
Like this (I know the formatting is messed up but you probably get my point):
A B C
Location 1 10 12 4
Location 2 5 55 1
Location 3 2 41 12
FIRST DIV 17 108 17
Location 4 66 5 4
Location 5 33 44 12
Location 6 11 23 44
SECOND DIV 110 72 60
TOTALS 127 180 77
I cannot figure out how to do this. It seems that you can only perform calculations on columns as a whole. I have seen references for formulas in various books/resources but none of them seem to state how to calculate formulas in this way.
Like this (I know the formatting is messed up but you probably get my point):
A B C
Location 1 10 12 4
Location 2 5 55 1
Location 3 2 41 12
FIRST DIV 17 108 17
Location 4 66 5 4
Location 5 33 44 12
Location 6 11 23 44
SECOND DIV 110 72 60
TOTALS 127 180 77
I cannot figure out how to do this. It seems that you can only perform calculations on columns as a whole. I have seen references for formulas in various books/resources but none of them seem to state how to calculate formulas in this way.