title: Excel if statement / Sum of Column
body: <p>I'd like to create a formula to say if anything in A column has "Admission" then sum the adjoining B column. I know I could do this cell by cell and sum up the cells, but is it possible to have one text box that can do this by itself?</p>
  
  <p>I'm creating an Expenses page for our honeymoon to see where the money is going. I should be able to see how much we spend on Admission prices, Hotel, etc. But to keep it simple, I didnt want to make a bunch of boxes that has random value in it if I could avoid it. So I created a summary page that has a text box for a specific day. So for September XX, I could select the boxes, and if it has "Admission" in one field (simple reasons A column) then I would like to add the B cell next to it to obtain a sum. </p>
  
  <p>I've looked up everything but can't seem to get it to work. So now, I'm asking for help.</p>
  
  <p>Thank you!</p>
  
  <p>A1 Breakfast - B1 $5</p>
  
  <p>A2 Lunch - B1 $5</p>
  
  <p>A3 Dinner - B1 $5</p>
  
  <p>A4 Admission - B1 $5</p>
  
  <p>A5 Event - B1 $5</p>
  
  <p>A6 Admission - B1 $5</p>
  
  <p>A7 Snack - B1 $5</p>
  
  <p>A8 Event - B1 $5</p>