Running total formula that skips blank cells

[pittsburghr2]

I have a column of results (Column A) and the cells are populated with Win, Loss, Tie, or the cell is blank. In column B, I want to keep a running total where a win adds 1 to the total, a loss subtracts 1, and a tie keeps the total the same. I can make this work with the following:

=IF(LEFT(A2)="W",B1+1,IF(LEFT(A2)="L",B1-1,IF(A2="T",B1,B1)))

This will keep the running total for all four cell possibilities and look like this:

01.jpg

But what I really want is when there is a blank cell in column A that the adjacent cell in column B also be blank but keep the running total. Like this:

02.jpg

Since I never know how many blank cells there will be I don't know how to do this. Any help would be greatly appreciated.

[Jonmo1]

Try this in B2 and filled down.

=IF(A2="","",COUNTIF(A$2:A2,"W")-COUNTIF(A$2:A2,"L"))

[samba_ravi]

=if(a2="","",countif(a$2:a2,"w")-countif(a$2:a2,"l"))
try this and copy towards down

[pittsburghr2]

Exactly what I needed. And much cleaner than what I was doing before. Thanks SO much for taking the time.

[Jonmo1]

You're welcome.