Hi There,
I'm looking for help to write a few formulas please.
In my data set, column P,Q,R&S contains over 500 rows of data, some of the cells are populated with a date others are blank.
Column P captures the date that a work activity moved into stage 1.
Column Q captures the date work started.
Column R captures the date work ended
Column S captures the date work exited stage 1.
I need 4 formulas in total. once I understand the logic I can then adapt these, as have over 8 stages to calculate.
I have looked at a combination of counta, countblank and countifs but I can't work the logic for even the first formula. I haven't used excel for the last 4 years so this is definitely a challenge for me.
Formula 1
If column p has a date I need a count of column q without date. This will tell me count of work which has gone into stage 1 but yet to start.
Formula 2
if column p has a date I need a count of column q with a date but column r does not have a date. So work has gone in and started but not finished.
Formula 3
if column p has a date I need a count of column q with a date but column r does have a date and column s doesn't. So work has gone in and started, finished and not exited.
Formula 4
if column R has a date I need a count if column s has a date. So work has finished and exited.
Many thanks for reading, hope it makes sense!
I'm looking for help to write a few formulas please.
In my data set, column P,Q,R&S contains over 500 rows of data, some of the cells are populated with a date others are blank.
Column P captures the date that a work activity moved into stage 1.
Column Q captures the date work started.
Column R captures the date work ended
Column S captures the date work exited stage 1.
I need 4 formulas in total. once I understand the logic I can then adapt these, as have over 8 stages to calculate.
I have looked at a combination of counta, countblank and countifs but I can't work the logic for even the first formula. I haven't used excel for the last 4 years so this is definitely a challenge for me.
Formula 1
If column p has a date I need a count of column q without date. This will tell me count of work which has gone into stage 1 but yet to start.
Formula 2
if column p has a date I need a count of column q with a date but column r does not have a date. So work has gone in and started but not finished.
Formula 3
if column p has a date I need a count of column q with a date but column r does have a date and column s doesn't. So work has gone in and started, finished and not exited.
Formula 4
if column R has a date I need a count if column s has a date. So work has finished and exited.
Many thanks for reading, hope it makes sense!