Excel Formula

Copper Contributor
I am failed to solve a probably a simple formula. Please Help me out with the formula -
I am trying to make a result sheet on Excel. I want to calculate Grad Total of all Subjects SUM D13, G13, J13, M13 along with P13 (in P13 the value has to be grater than 40, if the figure in P13 is 49 only 9 will be added/counted with the previous SUM). Here, (B13 = Writen, C13 = MCQ and D13 is Subject Total)

Note: D13 is =SUM(B13,C13) G13 is =SUM(E13,F13) and so on...
3 Replies
Try this:
=SUM(D13,G13,J13,M13,
MAX(P13-40,0))
Thank you very much. It worked!
You’re very much welcome!