Edit: <------ Posts: I'm leet.
I figured out what ANZAHLSUMMANDEN is. This is a user-defined function counting the number of summands in the argument cell. I don't know VBA well but I found that this works as a replacement:
Function SUMMANDS(cell As Range) As Integer
SUMMANDS = Len(cell.Formula) - Len(Replace(cell.Formula, "+", "")) + 1
End Function
Actually, I think the function we want is Substitute, not Replace. I get a wrong number of arguments error with the Replace function.
So this is what I have in the cell:
=Len(F4)-Len(Substitute(F4,"+",""))+1
However, both
Len(F4) and
Len(Substitute(F4,"+","")) are coming up with the same number which it shouldn't for the spreadsheet to work. Any suggestions?
Edit: I feel silly. Having looked at it more, I now see that the function isn't looking at the formula in the target cell; it's looking at the result. So the Len function is only telling us how many digits there are in the result . . . which is not what we need.
Well,i want a stat masta that i can download. Can you upload stat masta to a site,so we can download it?
You can download it right now from that link I gave in my earlier post (File > Download as > Microsoft Excel). But, 1) you'll need to paste over my formula changes with the original (just copy and paste from a cell that has the original formula in it [i.e. M9]) and 2) it still may not work depending on how much is lost in the conversion process from Google Docs to MS Excel.