EXCEL VBA/CALCULATION - Adding Totals From Selected Cells...

M

mesh

... with the use of tick boxs.

Hello and thank you for taking your time to open up this topic. Wel
first of all is to set the scenario. I am creating a worksheet on
computer company in which i have selected peripherals for exampl
monitors.

E.g.
a_________________b_______________c______ d________
TFT
15" £179.00 £210.33 1
17" £239.00 £280.83 2
19" £299.00 £351.33 3
4
CRT 5
17" £86.19 £101.27 6
19" £111.39 £130.88 7
____________________________________________________

after the second list of total i have check boxes. This is were i nee
help. I want to be able to tick a checkbox and the value thats in th
cell next to it will add to the total box at the bottom.

E.G Again
Something Like That :/
If D1 is checked then £210.33 + (total cell) = D21

IF you dont understand that please say and il try to explain mysel
again. as i am a newbie when it comes to spreadsheets. :) thank yo
very much :
 
F

Frank Kabel

Hi
try the following:
1. Add your checkboxes
2. Link each checkbox to the adjacent cell (lets say in column E). You
can hide this column if you like. If checked this column will show TRUE
for each checkbox
3. Now you can calcualte your total for all rows which have been
checked (I assume your values are in column C):
=SUMIF(E1:E20,TRUE,C1:C20)

HTH
Frank
 
M

mesh

How do you link the cells like you said?

"Link each checkbox to the adjacent cell (lets say in column E). You
can hide this column if you like. If checked this column will sho
TRUE
for each checkbox"

Im using control toolbox check boxs should i be using something else :
thank
 
F

Frank Kabel

Hi
your attachment is invalid. If you like, mail me a sample sheet
(frank[dot]kabel[at]freenet[dot]de)

Frank
 
M

mesh

I probably removed before you clicked the download link, :) but one o
your other posts solved my problem thank you :
 
Top