I'm trying to find a running sum on a spreadsheet with the formula
=IF(ISNUMBER(S2),SUM(S$2:S2),"")
Not every cell in column "S" is a number many are blanks. But as the image indicates the formula returns a blank.
What's wrong with the formula?
IsNumber error
-
bknight
- BronzeLounger
- Posts: 1504
- Joined: 08 Jul 2016, 18:53
IsNumber error
You do not have the required permissions to view the files attached to this post.
-
bknight
- BronzeLounger
- Posts: 1504
- Joined: 08 Jul 2016, 18:53
Re: IsNumber error
Nevermind, the cel reference is incorrect, should be S3 not S2 and the sum changed also.