Voila! Only the filtered cells in the column are summed up. Select the range with the numbers to add up and click AutoSum under the Home tab.Uncheck Select All and tick off only the value(s) to filter by.Click on the arrow next to the correct header to narrow down the data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |