Hi,
Can someone help me with a formula to calculate the final score where every unit will get additional score of 5 if that group sum has gone above 250?
Thanks.
Aleena.
Hi,
Can someone help me with a formula to calculate the final score where every unit will get additional score of 5 if that group sum has gone above 250?
Thanks.
Aleena.
In P10
=IF(SUMIF(C:C,O10,D:D)>250,SUMIF(C:C,O10,D:D)+5,SUMIF(C:C,O10,D:D))
Or
=SUMIF(C:C,O10,D:D)+(IF(SUMIF(C:C,O10,D:D)-250>0,5,0))
Last edited by JohnTopley; 07-21-2017 at 03:35 AM. Reason: Added more info
Try
P10Formula:Please Login or Register to view this content.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Thanks for replying.
However, that's not what I was looking for. I want to put a formula to calculate an additional weightage of 5 to the score for every unit (U1 U2,.....) in the column E.
For example, Group J has scored 263 points (i.e.,>250), so every unit in group J will get 5 more points. I have manually added 5 to show my requirement in all the eligible units in the column E.
Last edited by aleenkhan; 07-21-2017 at 06:13 PM.
Ok Try
E2Formula:Please Login or Register to view this content.
Great. Thanks for your help. It's sorted now.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks