Greetings and some help needed
Hi.
It's my first time here, since only now I needed some help in excell, and, to be honest, I'm killing myself here... only because just now I realized that I'm a noobie!
I have several doubts, but I don't want to be annoying, so I'll post them by themes.
What I'm trying to create it's somehow a "database" of online bets done and to do (soccer).
I'll have several spreadsheets, divided by countries.
In each sheet, I'll have this columns:
- Teams I'm betting;
- Date of the bet;
- Bet value;
- Result.
In a final sheet, I would like to have the sums of this all.
So, my first questions:
- Lets say I have 8 bets to be played on July, 21th.
- Is there a way to automatically make this dates be highlighted in this final sheet? Changing the colour, for example.
- Is there a way to automatically sum all the bets made on the the 21th?
Example: bets in 3 different sheets (sheet 1 - D8, D9 for the bets and C8 and C9 for the date; sheet 2 - E9, E10, E11 and E12 for the bets and D9:D12 for the date; sheet 3 - C7 and C8 for the bets and B7:B8 for the date), and I want to automatically return the value of these sum to the final one (lets say, sheet 10 - B3)
Sorry for my poor english and thanks.
Greetings,
Rui P.
Recent comments
5 years 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago