The calculator uses =sumifs(H3:H,G3:G,“Needs”) to get data from categories sheet after we change the Groups to Needs, Wants & Freedom, which I don’t want to as I prefer an in-depth view of my expenses arranged in multiple groups, as well as for the Envelope Savings Budget.
So I tried changing the SUMIFS to =sumifs(H3:H,G3:G,“Living”) and adding multiple group texts in the forumla such as:
- sumifs(H3:H,G3:G,“Living” OR “Bills”)
but none of this is working. So I’m confused that if we can actually do this or not? I tried reading some docs but it didn’t help.
Maybe I can just create a new row in the Categories sheet and use it specifically for the 50/30/20 calculator. How does this sound?
Let me know what do you guys think.