Forum Discussion
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
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
Emma, AGGREGATE is similar to SUBTOTAL but have wider range of functions and allows to ignore errors, hidden rows, etc
Great will have a go at using this function aswell
Thanks
Em