Forum Discussion
emma crawshaw
Sep 14, 2017Copper Contributor
Adding up Autosums as a total Sums in excel
Hi, I just want to know if anyone knows the formula to add up a colum with about 12 Autosums in to get the total sum of the Autosums. Thanks Em
emma crawshaw
Sep 14, 2017Copper Contributor
Hi Sergei,
Thank you for your reply. Fantastic I used the SUBTOTAL throughout and it's worked! I was using AUTOSUM and then trying to pick all them up with a SUBTOTAL.
Will have a to have a look at the AGGREGATE as I have never used this function. What does the AGGREGATE actually achive?
Thank you very much for your help.
Em
SergeiBaklan
Sep 14, 2017Diamond Contributor
Emma, AGGREGATE is similar to SUBTOTAL but have wider range of functions and allows to ignore errors, hidden rows, etc
- emma crawshawSep 14, 2017Copper Contributor
Great will have a go at using this function aswell
Thanks
Em