Count numbers in columns

Ok I have posted the workbook.


I now know how to count numbers in column

however I have a big issue.


I need to be able to stop counting the numbers also.


So for that on Sheet 1 I added RESULT

I want if that = "W" then for that not to be counted anymore...

Make Sense?

So Column C has the week number and column D has result "W" "L" or blank
I want when counting to look at the neighboring cell and to see if it is a win or loss before counting.

Matt