I am trying to get a countifs formula to work where the final criteria is an 'or' statement.
The formula looks like this but is not returning the correct value.
=sum(COUNTIFS('Source Data'!A:A,"Mark", 'Source Data'!B:B,"Approved",'Source Data'!C:C,{"PROCESS", "STRATEGY","Hybrid"}))
I have attached a sheet showing raw data example
As Ron says in the comments you need to remove trailing spaces from "Strategy"....but also your formula is an "array formula", so it will work OK in the latest versions of excel, but in older excel versions it needs to be "array entered" with CTRL+SHIFT+ENTER and in google sheets you need to wrap in "arrayformula" function like this:
=arrayformula(sum(COUNTIFS('Source Data'!A:A,"Mark", 'Source Data'!B:B,"Approved",'Source Data'!C:C,{"PROCESS", "STRATEGY","Hybrid"})))
...or use SUMPRODUCT like this:
=sumproduct(COUNTIFS('Source Data'!A:A,"Mark", 'Source Data'!B:B,"Approved",'Source Data'!C:C,{"PROCESS", "STRATEGY","Hybrid"}))