summing text

[dinopug]

I want to create a column where the user can input ANY data (number, symbol, letter, etc.) and create a sum. Basically, I want to be able to add "checkmarks" where the checks have a predetermined value based on the column the check is placed.

[Paul]

Hi Dinopug,

I'd suggest providing a sample worksheet that has sample data (which reflects your real data and layout) as well as the expected results. It's likely something that can be done via macros.

[dinopug]

Here is the spreadsheet I am working on. I want the user to input ANYTHING in the cells of column PTO. The value of the input is 8. At the the bottom I want a total for the week (an integer), this total will be added to the total hours later.

Some of the cells will be blank and others will have data. Sort of binary in a way with a value of "0" if the cell is empty and a value of "1" if it's not.

[Paul]

Does this work for you?

=COUNTA(H12:H18)*8

[dinopug]

Paul,

So far so good, I am going to take it for a test drive and will keep you posted.

[dinopug]

Paul,

This worked perfectly.

The problem was solved.