Excel if statement / Column sum
I would like to create a formula to say that if anything in column A has "Input" then sum the adjacent column B. I know I can do this cell by cell and sum cells, but is it possible to have one textbox, which can do it by itself?
I am creating an Expenses page for our honeymoon to see where the money is going. I have to be able to see how much we are spending on entrance prices, hotel prices, etc. But to keep it simple, I didn't want to create a bunch of boxes that have random value if I could avoid it. So I created a pivot page with a text box for a specific day. So during September XX I could select fields, and if it has "Input" in one field (simple column reasons) then I would like to add cell B next to it to get the amount.
I've searched everything but couldn't get it to work. So now I'm asking for help.
Thank!
A1 Breakfast - B1 $ 5
A2 Lunch - B1 $ 5
A3 Dinner - B1 $ 5
A4 Entrance - B1 $ 5
A5 Event - B1 $ 5
A6 Entrance - B1 $ 5
A7 Snack - B1 $ 5
Event A8 - B1 $ 5
source to share
Use the following formula:
=SUMIF(A:A, "Admission", B:B)
If you put in a table and instead of entering the expense type in forumla, you refer to the table column header, you can even copy paste the formula for a quick sum of all types!
By the way, I track my own expenses the same way using a spreadsheet: p
(You can do the same with CountIf
to get a meter and calculate the average flow. Min and Max are a little more complicated.)
source to share