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.
    • tesh288's avatar
      tesh288
      Copper Contributor
      Aug 17, 2024
      I didn't. Let me try that.

Resources