Formula to total whole numbers but ignore percentages

[fumusic]

I have a daily tally of Tom, Richard, & Harry's scores. At the end of each week, there is a column to work out the weekly percentage of their scores between the three of them. I need to find the total score up to date for each player. The problem is when I sum the numbers in the row it adds the percentages in the total too. Is there a way to ignore the percentages? Please note there are many weeks in the table so I can't just select the percentage columns to minus from the total. Once I have the correct formula I will be able to deduce how to work out the total percentage win up to date. It would be just the same ignoring the daily scores. Sometimes, you may get one player getting 100% of the weekly win so make sure the 1 as a representation of 100% won't be counted as a whole number but as a percentage.

[Fluff13]

How about

Please Login or Register  to view this content.

[63falcondude]

Try these:

T2 =SUMIF(B$1:S$1,"<>Weekly %",B2:S2)
U2 =T2/SUM(T$2:T$4)

[63falcondude]

Glad we could help. Thanks for the rep!