I have a worksheet with 6 different items that are totaled approximately 140
times in separate cells in the same column. These sums for each individual
item need to be put into a Grand Total on another worksheet.
I have tried to write =sum( and then click on each individual cell to add
them up, but I get a message saying the formula is too long.
I'm thinking I need to use a filter function for this, but I can't seem to
find one that works.
I am very new to working with Excell and would appreciate any help I can get.