Hi Guys, probably a very basic problem - but here goes. Im setting up a budgeting excel sheet for a student and I want to get a value based on a category selection on one sheet and for the total to be updated (added together) on another sheet. As there are 3 different categories I was thinking of doing 3 different If Else Statements to produce the totals on the other sheet but I cant seem to get it working to add another together..
Any help would be great.
Need to be a whole lot more specific than that. An example workbook may help, but be clear about your requirement.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Apologies for that - If Category A/B/C is selected in Column D on sheet 'Expenses to Date ' I want to be able to total all of each category which is selected and then totalled in the current spend column in the 'Fixed Budget' sheet. I may be completely wrong in the IF Else statement approach. Again any help or pointers would be appreciated. Worksheets attached.
On worksheet [Fixed Budget], enter the following formula in cell D4:
Formula:
Please Login or Register to view this content.
Copy and paste to cells D5:D6
Hi Olly, Thanks for that - could you explain the logic behind it so I dont make the same mistake again - I was trying to do If then Else statements with multiple outcomes for A,B,C which was obviously wrong..
The IF (x then a else b) function will choose between two outcomes, based on a criteria.
In your case, you are trying to sum multiple values, based on a criteria, so the SUMIF function is exactly what you need.
Gotcha - Thanks for that.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks