Forum Discussion

tesh288's avatar
tesh288
Copper Contributor
Aug 16, 2024

#NUM error

Hi everyone Kinda new here, but I believe I'm in the right place for the problem I would like solve. This formula...    =SUM(SMALL((G8,I8,K8,M8,O8,Q8,U8,W8,Y8,AA8,AC8),{1,2,3,4,5}))+S8   ... doe...
excel
m_tarler's avatar
m_tarler
Bronze Contributor
Aug 16, 2024
works fine on my PC. what version of Excel are you running on your PC? You might (probably) need to update it.
  • tesh288's avatar
    tesh288
    Copper Contributor
    Aug 16, 2024
    I'm using Office 2013.

    What's fascinating is that the same formula, but with large function in it works just fine.
    • m_tarler's avatar
      m_tarler
      Bronze Contributor
      Aug 16, 2024
      that is interesting. that old of a version doesn't support dynamic arrays. did you try using ctrl-shift-enter to enter the formula?
      • tesh288's avatar
        tesh288
        Copper Contributor
        Aug 18, 2024
        Ctrl-Shift-Enter isn't working as well. So, I guess I'm gonna have to go with an update for excel.

Resources