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
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