Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
If I use Data -> Filer -> Auto Filter in Excel and choose the criteria, what formula will sum/total?
So what can I use to total at the bottom? I don't want SUM as that ignores the fact I have chosen to filter the list.
Thank-you for your time & I will vote for ten points for the best answer.
2 Answers
- Anonymous1 decade agoFavorite Answer
not sure. AFTER you've filtered the data, using the Σ icon will give you =subtotal() and only the filtered cells will add up.
you need to check to see what happens if you unfilter or change the filter criteria to make sure its robust to those things.
- bulgarellaLv 44 years ago
listed under are my solutions.... a million. Mahatma Gandhi 2. Gulab Jamuns. Yummmm.... 3. in college, I positioned on denims and a t-shirt and to the an Indian party or something, I positioned on Salwars. it is annoying. i don't understand. people say i seem greater useful with denims. 4. Delhi 5. vehicle 6. Air stress 7. All 3!!!!!!! 8. English (I ought to) 9. Cricket, yet hockey is a brilliant number of exciting to visual show unit. So perhaps hockey? 10. Chak de India. =)
