Complete numpty when it comes to spreadsheets as never really had to use them, (read, got my PA to do them when I had one)..
So, trying to create a daily running total displayed, it's for medications as a guide for me to watch the old UN's, especially as with dementia creeping in, I need to be able to work out if they've remembered to take tabs..
Spreadsheet help..
-
Insane_Homer
- Posts: 5060
- Joined: Tue Jun 30, 2020 3:14 pm
- Location: Leafy Surrey
Probably a pivot table to make sense of the raw data, you can then add Slicer to filter the data.
Pivot Table
Slicers
Pivot Table
Slicers
“Facts are meaningless. You could use facts to prove anything that's even remotely true.”
If you want to sum total of column next to it.
Say if C has daily pills
D is blank with total pills which you want to be the sum
In cell D2, put =C2
In cell D3, put =D2+C3
Then copy the D3, and paste it in D4, and so on.
D should then be the total of C
Say if C has daily pills
D is blank with total pills which you want to be the sum
In cell D2, put =C2
In cell D3, put =D2+C3
Then copy the D3, and paste it in D4, and so on.
D should then be the total of C
-
Insane_Homer
- Posts: 5060
- Joined: Tue Jun 30, 2020 3:14 pm
- Location: Leafy Surrey
“Facts are meaningless. You could use facts to prove anything that's even remotely true.”
not that illiterate...-
OomStruisbaai
- Posts: 14013
- Joined: Fri Jul 03, 2020 12:38 pm
- Location: Longest beach in SH
Love Excell.