Formula to add one if cell isn't blank

[batjl9]

Hi guys

I have attached a file which shows what I am looking for.

Basically it is a table in which I have a column for how many wins a virtual horse started on when I bought it. Then it has a column for how much profit or loss I have made for each win I get since I bought the horse.

What I would like is a formula in the column 'wins now' (B2) which adds up wins before from cell A2 + if Cells C2:D2 (could eventually go to C2:V2) aren't blank, add one for each.

Thanks in advance
Gemma

[Fotis1991]

Try

Please Login or Register  to view this content.

[TMS]

Maybe:

Please Login or Register  to view this content.

Regards, TMS

[ben_hensel]

So I came up with two solutions.
Right now I've got C2:D2 as the range, but you can change that to C2:V2 no problem if you want.

1) Array Formula
{=SUM(A2,IF(ISBLANK(C2:D2),0,1))}
enter with CTRL+SHIFT+ENTER not just enter

2) COUNTIFS
=A2 + COUNTIFS(C2:D2, ">0")
Note this counts which cells have a number that's more than zero, not for empty cells. So if you have a text string in one of those then it won't count it.

Well, the countifs is probably better, it's just that the array formula occured to me first.

[batjl9]

Thanks for all the solutions guys, greatly appreciated.

Gemma

[TMS]

You're welcome. Thanks for the rep.