Total items using tick boxes

**brad26** · 03-04-2013, 02:33 AM

im new here and just cant figure out how to do this i am using excel 2007 making a list
wanting to know the formulas for this to work

ok here is what i want to do
i have a price and next to a tick boxs
i want to have a total of if the cell is ticked then the item would be + and all ticked items would have a total the the end , i dont no how to do this
sorry if i sound concussed
thanks for any help

**martindwilson** · 03-04-2013, 05:32 AM

if you just want a total of ticked then
=SUMIF($G$32:$G$51,TRUE,E2:E21)

**brad26** · 03-06-2013, 11:36 PM

thank you this has helped can just just explain alittle so i can do it with the other ones to

**martindwilson** · 03-07-2013, 08:10 AM

Read the help file on sumif it explains it better than i can
but notice both
G32:G51
E2:E21
have the same number of cells
every cell in range G32:G51 that has true
sum the corresponding value in E2:E21
is summed so g32=true add value from E2
g38=true add value from E8