Microsoft Office Questions? Ask a IT Expert for Support ASAP
Hi, My name is Andrew
I can help you with this
can you provide the formula you have so far?
I can send you the excel sheet with the information in it and what the calculations answer should be
Lets assume that the column you want to sum is the D column and it contains letters and numbers.So assuming you want to sum cells D1 - D25, the following formula would help you
the way this works is the first part sums only the numbers, the second part counts all of the Rs and multiplies those by 3 and adds to previous total, the 3rd part does the same accept for the Ls
You can change the ranges if you need to.
Remember that the range (D1:D25) in this example is in 3 places in the formula, to apply it to your range, you would need to change in all 3 places to be the same range.
Let me know if you have any problems with this formula or need my help further
Can I also do the same for a double ringer RR, Leaner LL
Also can a ringer plus closest to the pin work R1
(3 points for the ringer and 1 point for the other shoe?)
So far everything is very close
Do you need me to send the excel sheet?
That way you can see what I am talking about?
There are 17 columns and 4 rows on the score sheet
WIKISEND FILE ID# XXXXX
Column U has what should be the correct answers.
Let me know
That link brings up a virus alert and I can not open it.
If you can just cut and paste the info or e-mail me the formula at [email protected]
Virus not here just AVG picked it up as one.
Anyway the last formulas worked out great