Q: How would you construct an Excel formula to calculate your grocery expenses as part of your total expenses? For example, if your total grocery expenses for the month were $230; what percent would

that be of your total expenses of $2,300? (answer: 10%

A: If you know how to use formulas in excel, you can tag grocery expenses using a numeric or string value and then use SUMIF to calculate its sum. [ The % will then be another cell which uses both the total expense and grocery expense cells using another formula. ]

sharpies|Points 6998|

Question

Asked 3/12/2012 8:22:18 PM

0 Answers/Comments

Rating

There are no new answers.

25,747,499 questions answered

There are no comments.