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
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