Hello,
My colleagues have set up a sheet to help them track sustainability actions in their department. They've asked me to help with setting up reports and a dashboard that summarise and calculates the types of actions across the 4 Action type columns, as well as summarising further by team.
As you can see there's been an entry in the sheet already, but neither Materials & Waste or Energy is registering with the formulas I've used:
=COUNTIFS([Type of Action #1]:[Type of Action #1], "Materials & Waste", [Type of Action #2]:[Type of Action #2], "Materials & Waste", [Type of Action #3]:[Type of Action #3], "Materials & Waste", [Type of Action #4]:[Type of Action #4], "Materials & Waste")
=COUNTIFS([Type of Action #1]:[Type of Action #1], "Energy", [Type of Action #2]:[Type of Action #2], "Energy", [Type of Action #3]:[Type of Action #3], "Energy", [Type of Action #4]:[Type of Action #4], "Energy")
I think what it's doing is calculating only when all 4 columns has these values in, not counting up when it may be in only 1 or more columns, so I think it needs an OR function in there somewhere, but I'm stumped how to do this.
Any advice would be much appreciated!