countif

Hey; I am using excel as Office is the only identical software in all the PCs in my workplace. What I want to do for example: I have a sheet with equipment for each location in columns and another sheet with database of equipment name and condition (run, breakdown, maintenance,etc.) So what I...