I keep track of my live poker sessions in excel and one of the stats I have is the moving average for the last 50 sessions played at a particular game/limit (1/2 NL for example) so I can see if my play seems to be improving over time. When I first started playing I was playing 1/2 NL exclusively and playing long sessions. Now I've moved up and most of my 1/2 NL sessions are very short ones where I was essentially waiting for a seat at the game I really wanted to play. Needless to say the number of hours played in my first 50 sessions and my last 50 sessions are totally different and the graph is hard to interpret for that reason.

So my question is: Is there a way to average say the last 100 hours played instead of say the last 50 seasons? I already have a row with cumulative hours played but I'm not sure what formula (if any) would be able to do this.

Thanks

what's the formula for the cell showing your average of the last 50 games?

=SUM(G3:G52)/SUM(H3:H52)


G column has win/loss for a particular session
H has hours played in session

M column has cumulative hours played

Change g52 and h52 to 102?

I think you're misunderstanding my question. I'm not asking how to get the last 100 sessions but how to get the last 100 hours. The sessions aren't the same length. My old ones tend to be long and my recent ones tend to be short. Not sure if it can be done without writing a VBA macro.

=SUMIF(M$3:M3,">"&M3-$N$1,G$3:G3)/SUMIF(M$3:M3,">"&M3-$N$1,H$3:H3)

where $n$1 is an input field for 100 in case you want to change it easily, otherwise can just put the 100 into the formula:

=SUMIF(M$3:M3,">"&M3-100,G$3:G3)/SUMIF(M$3:M3,">"&M3-100,H$3:H3)

if the prior 12 sessions total just under 100 hours, this formula will include the 13th session in total

good enough?

the formula shown is for row 3 and you just copy it down. row 52 will look like:

=SUMIF(M$3:M52,">"&M52-$N$1,G$3:G52)/SUMIF(M$3:M52,">"&M52-$N$1,H$3:H52)

You are genius suited fours. That worked, thanks.

ya know, I keep telling people that....

glad to help.