HI All
I posted on this site a few days ago and was helped greatly by people on here. I have tried to build on that work but I have hit a wall. I am trying to write a formula;
'If cell/s in column A is say dept X , then if the correponding entries in column D are numbers, if the corresponding entries in column D are not equal to the corresponding entries in column C, then count where the corrrespondng entries in column F are less than or equal to the corresponding entries in Column D
To help
Column A = Dept
Column C = Planned Date
Column D = Latest Approve Date
Column F = Completion date
My equation so far;
I get the result 0 when it should be a 3
Any help greatly appreciated
Thanks
Andy
I posted on this site a few days ago and was helped greatly by people on here. I have tried to build on that work but I have hit a wall. I am trying to write a formula;
'If cell/s in column A is say dept X , then if the correponding entries in column D are numbers, if the corresponding entries in column D are not equal to the corresponding entries in column C, then count where the corrrespondng entries in column F are less than or equal to the corresponding entries in Column D
To help
Column A = Dept
Column C = Planned Date
Column D = Latest Approve Date
Column F = Completion date
My equation so far;
Code:
{=SUM(IF($A$50:$A$62="MoD",ISNUMBER($D$50:$D$62),$D$50:$D$62<>$C$50:$C$62),$F$50:$F$62<=$D$50:$D$62)}
Any help greatly appreciated
Thanks
Andy