Quick formula question...

KatieDi

Hello

I'm trying to get a formula to work and I can't..

I have a column for Department, with a range of values, and a column for Status, again with a range of values.

What I'm looking for is when a department equals x and has a status of y. I'm using the following, but it doesn't work.

=countif((Department:Department, "GP Surgery", +(Status:Status, "complete"))

I'll then look to replicate for when the department is x but status is z.

Help!

Thanks

Katie

Protonsponge

Hello @KatieDi,

I think the formula below may be what you are looking for. When looking to "Count If" for more than 1 criteria, COUNTIFS is needed in place of COUNTIF.

=COUNTIFS(Department:Department, "GP Surgery", Status:Status, "complete")