Hey look! Another Excel problem...

I have an issue. I want to sum up the number of cells that have a checkmark within them. I'm sure it's simple but I'm having a bit of a fit about it. I know it can be done, just can't remember how. Thanks.

 

... I've not really used excel to do this but heres how I would do it (This may not be the 'right' way but i've tested it and it works.

A Checkbox isn't an excel object, its a forms object but it CAN be linked to a cell, so you can have a cell value change between true and false based on the the checkedbox 'checked' property.

Excel has an IF command so you can set a cell's value based on another cells value.

You maybe be able to see where I am going with this now, link each checkbox to a cell next to the checkbox relative to the number. make another column next to your column of numbers. set a forumla in one colum to set its value to the same as the list of numbers if true and 0 if false then SUM() that column.


I know that last paragraph makes no sense so you can just download the attached excel spreadsheet demo I made

To see the columns I have hidden select the whole sheet (CTRL - A) and right click on the column headers and click 'unhide'


This is only one way of achieving what you want but without more information I can't give you any other solution.

(You could also achieve this in MANY different ways using VBA)

You will need to rename the attachment from demo.xls.txt to demo.xls as the forum doen't support the uploading of xls files.

 

Thanks, Matt!! That was one way I figured I'd do it. Then a friend here at the office began working on the task. Between the two of us, we figured out exactly how to use the formulas, a font called Wingdings (for the checkmark) and a bit of patience to get the exact result we needed. It took like 5 or 6 steps. If anyone is interested, I wrote down step by step how to do it and would gladly offer it up just in case someone needed to make up basically a tally sheet. Thanks again for your help, Matt. I had the same idea as you but stopped short of actually doing it. So, now with your help, I have two ways to get to the end of the road. :cool