# assign number value to letter and sum with other numbers

#### dgpete

##### New Member
Hi all,

Newbie here so be gentle!
I have searched a lot but found nothing exactly like what I need. I thought it was simple but I can't get a IF, SUMIF or SUM of anything to work so far. I know it's me so i need HELP!

for an archery scoring spreadsheet I have a number of entries in a row (in the example below it is five scores) with values from 0 to 5 (whole numbers only). I also need to enter some of the 5s as an X for a hit in the X ring that still scores a 5, so a row would look like this:
row A B C D E F
score 5 X 5 X 4 24 (SUM of A1:E1 where "X" = 5)

no other letter values will be used, just the X=5, every other score will be a number from 0 to 5.

Then I need another cell that totals the numerical count of Xs for that ROW so for the above sample the cell would read "2".

Clear as mud?
Are there simple formulas that can do this?

Thanks MUCH!

Doug

### Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

##### MrExcel MVP
Hi all,

Newbie here so be gentle!
I have searched a lot but found nothing exactly like what I need. I thought it was simple but I can't get a IF, SUMIF or SUM of anything to work so far. I know it's me so i need HELP!

for an archery scoring spreadsheet I have a number of entries in a row (in the example below it is five scores) with values from 0 to 5 (whole numbers only). I also need to enter some of the 5s as an X for a hit in the X ring that still scores a 5, so a row would look like this:
row A B C D E F
score 5 X 5 X 4 24 (SUM of A1:E1 where "X" = 5)

no other letter values will be used, just the X=5, every other score will be a number from 0 to 5.

Then I need another cell that totals the numerical count of Xs for that ROW so for the above sample the cell would read "2".

Clear as mud?
Are there simple formulas that can do this?

Thanks MUCH!

Doug

Try...

=SUM(A1:E1)+COUNTIF(A1:E1,"x")*5

#### dgpete

##### New Member
Try...

=SUM(A1:E1)+COUNTIF(A1:E1,"x")*5

Works PERFECT!!! THANK YOU!!!!!

Doug

##### MrExcel MVP
Works PERFECT!!! THANK YOU!!!!!

Doug

You are welcome. Thanks for providing feedback.

Replies
1
Views
209
Replies
6
Views
188
Replies
2
Views
163
Replies
1
Views
107
Replies
3
Views
132

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,151,981
Messages
5,767,435
Members
425,413
Latest member
ccfam04

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back