Mikeeverest
Board Regular
- Joined
- Dec 29, 2008
- Messages
- 89
I am trying to obtain a % total for:
F1/E1 (61/6)=91% easy enough. The numbers are time service related and represent do or die. the goal was reach 61 times out of 67 = 91%
now i am trying to calculate for a secondary goal. in the 6 (above) there is 1 (unit) that was outside the second goal.
My formula looks like this:
=sum(e1+f1-h1)/sum(e1,f1)
Does that seem right?
Is there a more efficient way to write the formula?
F1/E1 (61/6)=91% easy enough. The numbers are time service related and represent do or die. the goal was reach 61 times out of 67 = 91%
now i am trying to calculate for a secondary goal. in the 6 (above) there is 1 (unit) that was outside the second goal.
My formula looks like this:
=sum(e1+f1-h1)/sum(e1,f1)
Does that seem right?
Is there a more efficient way to write the formula?