We help IT Professionals succeed at work.

Convert a column value to a number

Hi,

I have a spreadsheet with a column that contains either A, B or C (or blank).

I want to make a sum in the bottom of the column that awards 3 for an A, 2 for a B and 1 for a C, 0 for blank...

Is that possible?

tnx
~j
Comment
Watch Question

CERTIFIED EXPERT
Commented:
Hi, funch.

Assuming that the cells you're interested in are A1:A10...
=3*COUNTIF(A1:A10,"A")+ 2*COUNTIF(A1:A10,"B")+COUNTIF(A1:A10,"C")

Regards,
Brian.

Author

Commented:
problem is that they are not...

they are a spreadsheet with hidden rows, so it would be row 56, 75,90 etc. on one, but different on another...

any ideas on that... worst case scenario I can delete the rows, it's not the end of the world...

`j

Author

Commented:
Actually it worked, I just added the max number of rows and it worked...

tnx a bunch
~j
CERTIFIED EXPERT

Commented:
Thanks, funch.

As you've discovered, the formula doesn't care whether the rows are hidden or not. That's fine - unless you want to exclude A/B/C values in the hidden rows.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.