I am doing some data analysis (work project). I have 1 main worksheet with all the information, and for each snippit of info,I did a formula to add up everything.
Closest analogy to this would be checks. I have about 30 businesses I write checks out to.. I put the business name, the check # and the check amount. I have about 600 or so checks on this one excel sheet.
For each business, I did an autosum. Now I have 30 autosums across this one sheet. Is there some method of adding up every autosum (or formula) across this sheet to get a grand total?
if that is not possible, is there a way to add up every Currency Value Cell on a sheet.