Wins and Losses columns totalling the W's and L's?

**shivers** · 08-29-2013, 12:51 AM

Hello, I am creating a spreadsheet with rows as day of the month (27, 28, 29 just 1-2 digits), then to the right of each day putting W or L per cell down the row. I'd like to have a column that counts the total number of W's and a column that counts the total number of L's, how can I have this automatically tallied?

What I have so far:

\1

Thanks for any help!

**:) Sixthsense :)** · 08-29-2013, 12:54 AM

Use Countif formula

Formula:

Please Login or Register  to view this content.

Formula:

Please Login or Register  to view this content.

change the range reference A:B to your desired range.

**shivers** · 08-29-2013, 01:26 AM

Thank you, that worked!

**:) Sixthsense :)** · 08-29-2013, 01:36 AM

Glad it helps you and thanks for the feedback and rep

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

**shivers** · 09-04-2013, 06:40 PM

Marking this as unsolved for a moment as I have a follow-up question (if that's not allowed nevermind this and I apologize!)

I'm wondering if it would be possible to calculate streaks in the sheet, as in longest W or L streak? It would need to span rows from one day row to the next in case one day ended in 3 Ws and the next day began with 2, so a 5 W streak over 2 days.

Thanks for any help!

**Tony Valko** · 09-04-2013, 06:46 PM

How many cells of data are there per row?

How many rows might be included in the streak? More than 2?

**shivers** · 09-04-2013, 06:49 PM

I made a quick screenshot of a part of the sheet:

\1

(In the screenshot I have a W at the end of the 26th, then 2 more to begin the 27th so that would be a 3 W streak.)

**Tony Valko** · 09-04-2013, 07:12 PM

Hmmm...

Well, I'm not sure how to do this due to the possibility that many rows would need to be evaluated for a single count.

I guess it would be possible to have data like this:

Data Range

	A	B	C	D	E
2	25	W
3	26	L	L	W
4	27	W	W
5	28	W
6	29	W	W
7	30	W
8	31	W	W	W	W

What results would you expect from that data?

**shivers** · 09-04-2013, 07:46 PM

Thanks! I simply want one cell for W and one for L somewhere on the sheet that shows the longest streak for each. So longest W streak and longest L streak.

**Tony Valko** · 09-04-2013, 08:07 PM

Ok, based on the sample data I posted what would be the longest streak of Ws?

**shivers** · 09-04-2013, 09:17 PM

11, from 3-8 rows.

**Tony Valko** · 09-04-2013, 09:34 PM

That's what I was afraid of!

If the data was in a 1 dimensional array this would be relatively easy.

I don't know how to do this. Maybe someone else does and if so, I would love to see the solution.

**moppyau** · 09-04-2013, 09:50 PM

Hi All,
Attached is a sample using Tony's example. I can get a formula to count consecutive W's & L's per row. Maybe someone else can tweak it further.