I would like to create a budget based on categories of items. I would like to be able to add the items into category types so I can see what I spend of "Food" for example. I am trying to use the checkbox to not have the item in the row's cost added to the total. Screen shot below is for the total of the items in that category, but I want to say

=SUMIF($B$3:$B$100, $G2&A2<>true,$D$3:$D$100)

... but this isn't correct.

enter image description here

What I mean is with the check boxes checked, I want to ignore the first 2 "Travel Expenses" so they are not totaled. I want H2 to have a value of "$60.69", which is the total of 16.05 + 4 + 40.64

1 Answer 1


You can use the following formula:


You can further drag the formula down to calculate values for the rest fo your categories.

Functions used:

  • Please remember that as per site guidelines when an answer addresses your question, you should accept it so others can benefit as well. Commented Mar 21, 2020 at 2:37
  • Awesome, that is what I was looking for "SUMIFS"! Thank you!!
    – Tizz
    Commented Mar 22, 2020 at 7:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.