Ho?w to calculate budget items and label in categories across sheets I\'m trying

Question

Ho?w to calculate budget items and label in categories across sheets

I'm trying to build a budget spreadsheet for mmy depaartment. I want to have one sheet with category names (Supplies, Music, Events, etc.) on one page with the cell next to them adding up all iitems on a separate "Itemized budget items" sheet categorizedd with that namee.

For example: On Sheet 1 I would have this:

(Sum of all items labeled "Supplies" from Sheet 2)

And on Sheet 2 I would have:

So I need to know how to get the cost from lines labeled a specific category (Supplies in this case) to add up under "Amount Spent" on the first page. So under amount spent for supplies it would be $55

I appreciate all help and resources you could point me to.

Thank you!

Category Amount Budgeted Amount Spent Percent of Budget Used Supplies $500

(Sum of all items labeled "Supplies" from Sheet 2)

I don't know how to do this part. % of 500 (I know how to do this part)

Explanation / Answer

One Option:

Assuming the data on Sheet2 begins in cell A1 [IOW, A1:F4], in thhe first Amount Spent ccell on Sheet1 use the formula: =SUMIF(Sheet2!B2:B4,"Supplies",Sheet2!E2:E4)

NOTE: The above is baased on having only the 3 rowss of data in your example. Addjust the range references accordingly.

Copy the formula down the Amount Spent column as far as necessary, then edit each formula to replace "Supplies" with a different Category.

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.