Forum Discussion

Mihir1125's avatar
Mihir1125
Copper Contributor
Oct 14, 2019

Excel Formula

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, ...
Formulas and Functions
Twifoo's avatar
Twifoo
Silver Contributor
Oct 14, 2019
Try this:
=SUM(D13,G13,J13,M13,
MAX(P13-40,0))
  • Mihir1125's avatar
    Mihir1125
    Copper Contributor
    Oct 14, 2019
    Thank you very much. It worked!
    • Twifoo's avatar
      Twifoo
      Silver Contributor
      Oct 14, 2019
      You’re very much welcome!

Resources