Forum Discussion
Solved
Creating a new Category and formula for it
I created a new category called Auto Fuel but don't know how to put the right formula, so it matches all areas where "Auto Fuel" is a category. For now, I just put an = sign and directed it to the one auto fuel input that I have so far. Every time I get gas, I want to see that amount increase.
I just started this, so forgive my ignorance.
Joe
- Hans,
I am sorry I didn't mention the layout, but I got the idea now and thank you very much.
The category is in F, and the amount is in O, so I will adjust the formula you have provided!
Have a great Day
Joe
You haven't provided any info about the layout of your workbook.
Let's say the categories are in C2:C100 and the amounts are in D2:D100.
The total amount for Auto Fuel is
=SUMIFS(D2:D100, C2:C100, "Auto Fuel")
or, if the text Auto Fuel is in cell K2:
=SUMIFS(D2:D100, C2:C100, K2)
- Hans,
I am sorry I didn't mention the layout, but I got the idea now and thank you very much.
The category is in F, and the amount is in O, so I will adjust the formula you have provided!
Have a great Day
Joe
