Newbie - easy for some

McLovin

i need a formula to look at 2 different columns and find and add if correct.

ie: total of Hazard reports A crew did.

Screenshot 2025-02-08 174240.png

Protonsponge

Hello @McLovin,

I think a COUNTIFS formula is what you would be looking for here:

The formula below will count the number of instances where [Crew] is "A" and [Incident] Type is "Hazard Report". In the demo below I have put this in a column but you could equally put this a sheet summary field too.

=COUNTIFS(Crew:Crew, "A", [Incident Type]:[Incident Type], "Hazard Reports")

I hope that is helpful to you in some way,

Protonsponge