Check box count!
 

Good morning everyone,
I have a cell W45 that take a count of all of the check box1 to chec
box 4. They are link to cell W39:w42. Cell W45 count each time I chec
it but when I unchecked, cell W45 still shows 4. Would any one help m
please to change this code so that it would give recount when chec
boxex are checked or unchecked.

=COUNTIF(W39:W42,TRUE)

*** I have cell P31 and P32 that need entries. I need a code that coul
give the count or sum of values from P31 and P32, and those four chec
box. For now I have to count all check boxes in one cell and hide i
cell W45 in white font, then sum W45,P31 and P32. I would appreciat
any help to combind these steps.

Thank you in advance!

Regards,
Kim-An

--
Message posted from http://www.ExcelForum.com

Check box count!
 

Make su Tools OptionsCalculation = Automati
=SUM(P31,P32,COUNTIF(W39:W42,TRUE)

----- Kim-Anh Tran wrote: ----

Good morning everyone
I have a cell W45 that take a count of all of the check box1 to chec
box 4. They are link to cell W39:w42. Cell W45 count each time I chec
it but when I unchecked, cell W45 still shows 4. Would any one help m
please to change this code so that it would give recount when chec
boxex are checked or unchecked

=COUNTIF(W39:W42,TRUE

*** I have cell P31 and P32 that need entries. I need a code that coul
give the count or sum of values from P31 and P32, and those four chec
box. For now I have to count all check boxes in one cell and hide i
cell W45 in white font, then sum W45,P31 and P32. I would appreciat
any help to combind these steps

Thank you in advance

Regards,
Kim-An


--
Message posted from http://www.ExcelForum.com

Check box count!
 

Hi
is automatic calculation enabled?. This formula should work


--
Regards
Frank Kabel
Frankfurt, Germany


Good morning everyone,
I have a cell W45 that take a count of all of the check box1 to check
box 4. They are link to cell W39:w42. Cell W45 count each time I
check
it but when I unchecked, cell W45 still shows 4. Would any one help
me
please to change this code so that it would give recount when check
boxex are checked or unchecked.

=COUNTIF(W39:W42,TRUE)

*** I have cell P31 and P32 that need entries. I need a code that
could give the count or sum of values from P31 and P32, and those
four check box. For now I have to count all check boxes in one cell
and hide it cell W45 in white font, then sum W45,P31 and P32. I would
appreciate any help to combind these steps.

Thank you in advance!

Regards,
Kim-Anh


---
Message posted from http://www.ExcelForum.com/