Software

Ask something
Question Locked

EXCEL Checkboxes

0 helpful
3 replies

by vintage.pt

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello all,

I need some help, since i really don?t know much from excel programming.

As a wine lover, i am building my tasting map in Excel, so i putted some Checkboxes in the sheet. Now, what i need to do is to make each CB's to correspond to a number and them finaly make a SUM of what was checked.
Any sugestions and help on this?

Best Regards,

Joao

3 replies

by absolutely

1. In a hidden column, use 'IF' function to set the cell = 1 if the checkbox on that row is checked, zero if unchecked.
2. In a cell, type:
=SUM(b1:b65536)

[assuming your other function, which evaluates to 0 or 1, is in column b]

by vintage.pt

Can you put a example for me to see?

I tried to put a macro with the if statement in the Checkbox but didn?t really work. You say to put the code in the cell?

Best regards,

Jo?o Rico

This discussion is closed to new replies.