Hi,
A complete Excel newbie here. I was tasked with figuring out how much was spent on each category in column C of the Summary tab in the Spring 2018 pulling data from the OTPS Expense Tracker Sheet (column B). I tried but failed. Can someone tell me how to set up a Sumif formula that will give me the relevant info? THANKS!
Dummy Excel sheet attached.
Try this in F4 and copied down:
Formula:
Please Login or Register to view this content.
It works like this:
Formula:Please Login or Register to view this content.
Think of it like filtering data and summing up a column in the remaining rows.
You will need to amend your data slightly to get the right values. For example, in your data you have "Seminar and Skills" but on your table sheet you have "Seminar & Skills". Also "Student Activities" is completely missing from your table. That could be deliberate but we really don't know enough about the project to be able to say for sure.
Hope it's of help.
BSB
Last edited by BadlySpelledBuoy; 09-17-2018 at 04:20 PM. Reason: EDIT: Worth noting that you could use a pivot table to do the same.
Thank you so much!!! It worked beautifully. I need to start brushing up on my Excel skills ;-)
We all started somewhere. I wish I was half as competent as some on this forum! (and I've made a living through spreadsheets for nearly two decades!)Originally Posted by TatyanaG
Ask the questions, get the answers, learn from them and you'll be here with answers for others before you know it.
BSB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks