I have the following code
What I need to do is have the above code, what I now need it to do is if there is a value in Column M in the Master sheet, is to repeat the same code and add the two formulae answers up. However, I only want it once per row.
So, if M2 had no value, it would perform the formula in L2, and if it is correct, then it would add one.
If there was a value in M2 and L2, I only want it to perform the formula in M2 (ignore L2's value completely.)
Hope that makes sense!
--|--COLUMN L--|--COLUMN M--|
-1-|-30/12/2018--|---[blank]----| (Counts only L)
Code:
=IF(Master!M:M="",COUNTIFS(Master!L:L,">"&(TODAY()+30),Master!L:L,"<>2958465",Master!O:O,"<>*Rejected*",Master!O:O,"<>*Completed*",
Master!C:C,"<>",Master!F:F,"<>BI"),"")What I need to do is have the above code, what I now need it to do is if there is a value in Column M in the Master sheet, is to repeat the same code and add the two formulae answers up. However, I only want it once per row.
So, if M2 had no value, it would perform the formula in L2, and if it is correct, then it would add one.
If there was a value in M2 and L2, I only want it to perform the formula in M2 (ignore L2's value completely.)
Hope that makes sense!
--|--COLUMN L--|--COLUMN M--|
-1-|-30/12/2018--|---[blank]----| (Counts only L)
-2|-30/12/2018--|-20/11/2018--| (Counts nothing as M is within 30 days, and M overrules column L)
-3|-30/12/2018--|---[blank]----| (Counts only L)
-4|-30/12/2018--|-30/12/2018--| (Counts Only M as M overrules L and over 30 days)
-5|
So would return a value of 3 (rows 1,3, and 4)
-3|-30/12/2018--|---[blank]----| (Counts only L)
-4|-30/12/2018--|-30/12/2018--| (Counts Only M as M overrules L and over 30 days)
-5|
---[blank]----
|---[blank]----| (No count)So would return a value of 3 (rows 1,3, and 4)
