...way for me to set a condition to the "subtotal"...

FAQS.ORG makes no guarantees as to the accuracy of the posts. Each post is the personal opinion of the poster. These posts are not intended to substitute for medical, tax, legal, investment, accounting, or other professional advice. FAQS.ORG does not endorse any opinion or any product or service mentioned mentioned in these posts.

<< Back to: comp.apps.spreadsheets FAQ

[ Home | FAQ-Related Q&As | General Q&As | Answered Questions ]

Question by Sovsy
Submitted on 1/27/2004
Related FAQ: comp.apps.spreadsheets FAQ
Rating: Not yet rated	Rate this question:
Is there a way for me to set a condition to the "subtotal" function so that it not only adds what is filtered but as well as what keyword i have asked it to search for?

Answer by gunner
Submitted on 6/28/2006
Rating: Not yet rated	Rate this answer:
you can set up spreadsheat to sort by range of cells with either a numeric code or word and subtotal within those chosen or have all sorted by catagory you set up( # or word) and then total subtotals from their. Use to do expenses breakdowns that way, off top of head formula looked somewhat like; =sumif(a1:b54,720,b1:b54) this will sort your codes in cells a1 through a54 and sum amounts in cells b1 through b54

Your name or nickname:
If you'd like to create a new account or access your existing account, put in your password here:
Your answer: