Help please

[jazz8922]

Please can I ask for some help.

I’m trying to work out a formula with multiple conditions without success.
Column A is date opens
Column b is date rejected
Column c is date closed
Column d is type of work

I am trying to get a formula that will tell me how many open cases I have for each type of work.

So I need a formula to tell me if b and c are blank. A is not blank and count the type of work(specific text).

Hope that makes sense

Thanks

 

[Legacy 143009]

Countifs is what you are looking for:

=COUNTIFS(D:D,"=workname",A:A,"<>",B:B,"=",C:C,"=")

 

[jazz8922]

Countifs is what you are looking for:

=COUNTIFS(D:D,"=workname",A:A,"<>",B:B,"=",C:C,"=")

Thanks for that I’ll give it a go tomorrow. Let you know if you have saved my sanity!! Cheers, Jazz