COUNTIF Alternative for multiple criteria?

[dan17602]

Hi all,

I am currently in the process of creating a lateness report

Example of the data sheet.

Col B = Lateness code ie "Lunch"
Col F = Duration of the lateness ("HH:MM:SS")
Col H = Area where they work

Basically what im after is to work out if the occurance is over 3 minutes to calculate the time over (Collum B) but only if the code is "Lunch" & area "Retail".

From my understanding I can't work this out with a single countif because it has more than one criteria?

Thanks in advance for any help

 

[syntaxed]

You can use Countifs for multiple criteria.
Assuming you have 1000 used rows with row 1 being column headers and row 2 onwards containing data, this may work:

=COUNTIFS(F2:F1000,">00:03:00",B2:B1000,"Lunch",H2:H1000,"Retail")

 

[dan17602]

Hi Syntaxed,

That worked great, exacly how I wanted

Thanks for your help!