[PaveFE]

Hi all,

Having some trouble making this work, so here's the deal. I have a spreadsheet to track people who have signed up for some events we're hosting in October. There are three events, each one costs $30. If they attend all three events, they get a free T-shirt if they want one. If they only attend one or two events and still want a T-Shirt, then the shirt is $10 extra. I need a formula to calcluate the total cost depending on what they sign up for and if they want a T-shirt. I have cells to indicate Yes or No for each event, and a Yes or No for the T-shirt. Please let me know if I need to explain more, but I think it covers it.

Thanks,

Vince

[PaveFE]

Never mind, I finally figured it out.

[Aj_old]

suppose that your answers for those 3 events are in Columns B, C, D and for T-Shirt in E, you can use this formula:

=COUNTIF(B3:D3,"yes")*30 +IF(E3="yes",IF(COUNTIF(B3:D3,"yes")<3,10,0),0)