How do I sum only the total in various groups? I can highlight the cells to get the total but when using the sum function I get the hidden rows too. I have attached an example spreadsheet to clarify my question. Thanks iGrouping Total.xlsxn advance!