G
Guest
Afternoon,
Sure just typed this, but anyway.
Scenario to explain.
I have a date in B11, with a value in F11 and another in L11 with more
values in O11:AA11.
So to explain my problem:
1. If there is a date in B11 AND OR
2. Cell F11 equals L11 but their values must not be zero
Then add O11:AA11
If all three of these criterias are meet then add up O11:AA11
I have this:
=IF(AND(B11="",F11=L11),0,(O11+Q11+S11+U11+W11+Y11+AA11))
Thanks
Sure just typed this, but anyway.
Scenario to explain.
I have a date in B11, with a value in F11 and another in L11 with more
values in O11:AA11.
So to explain my problem:
1. If there is a date in B11 AND OR
2. Cell F11 equals L11 but their values must not be zero
Then add O11:AA11
If all three of these criterias are meet then add up O11:AA11
I have this:
=IF(AND(B11="",F11=L11),0,(O11+Q11+S11+U11+W11+Y11+AA11))
Thanks