I have an excel spreadsheet with the following columns:
I want to count how many technicians will be working, but only if they have hours in the second column. So I would have a cell that would see that Billy and Bobby have hours applied, but Jimmy does not so my cell would say there are 2 technicians. If I added some hours to Jimmy, then the cell would count 3 technicians.
How do I do this? Multiple countif criteria? Sumproduct?