Working out the number of items in =1+2+3+4

Hi all,

I'm new to Excel and I don't know that much about it. I do know a little about VBA and am a programmer so I can make sense of stuff pretty easily.

I'm stuck though trying to find a way to look at an excel cell with something in it link: =12.68+6.74+4.54+4.4
Then I want to be able to find out how many numbers are being added together (in this example 4) so that I can then work out what the average number is.

It's important to me as I want to use this on my income tracking spreadsheet so I can see how many orders have been placed and what the average value is each day.

Any thoughts? Am I barking up the wrong tree here?

Mike

Don't know which tree you are barking up, but an easy way to do this in a formula is to count the + and add 1.

The vba code could do something like this to create a custom function

Function CountPlus(mySelection As Range)
myCount = 0
For x = 1 To Len(mySelection.Formula)
If Mid(mySelection.Formula, x, 1) = "+" Then myCount = myCount + 1
Next x
CountPlus = myCount + 1
End Function