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
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