Forum Discussion

Copper Contributor

Jan 07, 2018

SOMETHING SIMPLE . .

Hi all, Firstly , I am a complete lay person , thrown into the world of lottery syndicates , with ZERO prior knowledge of EXCEL - I`m just after making things a lot easier on myself. I`m after so...

Inverness Lottery Tracker 2018.xlsx23 KB

excel

Formulas and Functions

Damien_Rosario

Silver Contributor

Jan 07, 2018

Hi Ian

I'm not aware off the top of my head regarding a running total formula, but if you are reporting a week by week win then the sheet I have modified might suit.

All I have done is added additional rows to capture your weekly wins (5 weeks as some months will have 5 weeks in them) and a simple SUM formula to total the amounts as you change them.

Hopefully I am understanding you right. See what you think?

Cheers

Damien

Inverness Lottery Tracker 2018_DR modified.xlsx24 KB

Ian Parry
Copper Contributor
Jan 08, 2018
Thank you for the reply Damian it's not quite what I was after. as I tend to "hide" the ROWS once that week has passed.

Maybe i'm trying to do something which i'm not 100% sure about yet :)
- Damien_Rosario
  Silver Contributor
  Jan 08, 2018
  I sort of see where you are going with this. It's possible to just have it as you did before and have a running total formula for row 36. You can hide the columns as you need it and it won't affect the formula.
  
  Or as you say, see what you want and let us know if you still need help?
  
  Good luck!
  
  Cheers
  
  Damien