Forum Discussion

Sam Bird Bird's avatar
Sam Bird Bird
Copper Contributor
May 03, 2018

Sum Function help

Hi, further to my below post. I am trying to create a formula to automatically calculate the sum of inputs from IF/OR functions.   In the scorecard these If/Or functions will automatically put in a...
Excel Desktop
Formulas & Functions
Tomasz Kocur's avatar
Tomasz Kocur
Brass Contributor
May 03, 2018

Hi Sam

Enter in the f12 cell:

=SUM(D2:F2,D4:F4,D6:F6,D8:F8,D10:F10)

  • Sam Bird Bird's avatar
    Sam Bird Bird
    Copper Contributor
    May 04, 2018

    Hi,

     

    This is showing a sum of 0 rather than 10... It doesnt seem to be registering the numbers inputted by the formulas in each of those cells

     

    Formulas are for example : =IF(AND(C4>550,C4<=650),"3","")

     

    This gives a score of 3 in call F4 however the sum function does not seem able to sum these...

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      May 04, 2018

      Or use

      =IMSUM(D2:F2,D4:F4,D6:F6,D8:F8,D10:F10)

      if you prefer to keep scores as text

       

    • Tomasz Kocur's avatar
      Tomasz Kocur
      Brass Contributor
      May 04, 2018
      Hi Sam
      This is showing a sum of 0 because you have entered "1", "2, "3" with quotes instead of the number.
      PC interprets the characters between quotes as text.
      Please replaces the IF formula accordingly for example :
      From this =IF(AND(C4>550,C4<=650),"3","")
      To this =IF(AND(C4>550,C4<=650),3,"")

Resources