Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check 2 columns in range - count one | Excel Discussion (Misc queries) | |||
Count Check Boxes across Sheets | Excel Discussion (Misc queries) | |||
2 conditions needed to check and count of items based on that | Excel Worksheet Functions | |||
Count Check Boxes | Excel Worksheet Functions | |||
count check boxes | Excel Worksheet Functions |