Sarah T Cuttings
New Member
- Joined
- Oct 23, 2024
- Messages
- 12
- Office Version
- 365
- Platform
- Windows
I have a spreadsheet with coloured rows as below. The values in Column E are the total values of jobs, the colour, represents a region as per my snip of Cuttings London, Cuttings East & Cuttings West. The row with the £26,777 is row 96, column E.
What I would like to do is total all values as per their colours and if I chose to change the colour, the total value will update with the change.
Is this possible?
Thanks
Sarah
What I would like to do is total all values as per their colours and if I chose to change the colour, the total value will update with the change.
Is this possible?
Thanks
Sarah