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.
Anonymous
Favorite 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.
bulgarella
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. =)