I wrote the formula below to count the number of items in the 'Exposure' column that have a value greater than or equal to 2.5.

The formula must be based on 3 conditions:

1.) Column G equals a value
2.) Column B equals a value
3.) Column C does NOT equal "Closed" ---- I'm thinking this is where I messed up
the syntax.


I am getting a #VALUE error. Can someone please help me by reviewing the formula below and tell me where I messed up?

Thanks!



=COUNTIFS('Risks source data'!G:G,'Flagged Leadership'!E15, 'Risks source data'!B:B,'Flagged Leadership'!R24,'Risks source data'!C:C,"<*Closed*", Table_owssvrCASFE3I1[Exposure], "=2.5")