Hello, I have a constantly growing spreadsheet and have been manually highlighting all the cells I want to add up to see the total and then manually input. This is taking a long time.
All new data gets added as a new row so the total row is never going to remain fixed either.
There are three colours on the sheet. Green, blue and orange.
Can someone please tell me how I would instruct Excel to calculate the total value of green and blue in column H but ignore any in red?
Bookmarks