Summing the output of a formula at the end of a row

[flrae]

Hi all,

I am sure my problem is going to give everyone a giggle and I am happy to do that But this is driving me nuts. I have created a spreadsheet to capture the results of an upcoming horse show. There are multiple sections and aggregate awards to calculate. My IF functions appear to be working well but when I try to total up the scores at the end of the row I am completely lost. I have investigated the =VALUE, =SUM and =SUMPRODUCT functions with no luck.

In my example, I am attempting to sum the results in the blue cells to the location in the green cell that I have manually totalled.

Any help would be so much appreciated.

[windknife]

O4
=sum(iferror(--e4:n4,0))

copied down.

[HansDouwe]

Make the points numeric (by removing the qoutes in the corresponding formula) and try in O4 =SUM(E4:N4) and copy down.

[kvsrinivasamurthy]

I have changed If formula. In F4 copied to required range.

=IF(E4="1st",3,IF(E4="2nd",2,IF(E4="3rd",1,IF(E4="CH",5,IF(E4="RCH",4,IF(E4="","",IF(E4="-","")))))))


In Q4

=SUM(F4:N4)

[windknife]

F4 more simple.

=IF(OR(E4="",E4="-"),"",MATCH(E4,{"1st","2nd","3rd","RCH","CH"},0))

[flrae]

Wow, what an amazing response, thank you very much. Now it's time for me to have a little play with it. I love learning new things.

[windknife]

You are welcome.
--------------------------------------
If that takes care of your original question, please click on "Thread Tools" from the menu link above and mark this thread as SOLVED.

[HansDouwe]

You are welcome, glad to have helped and thanks for the feedback and rep .