I have the following:
B72= 1
C72= 1
D72= 1
E72 = 1
F72= 1
And:
B75 = ""
C75 = ""
D75 = ""
E75= 18
F75= ""
I need a sum of row 72 but only sum if there is a corresponding value in 75. So here the sum would be 1 since there is only one cell in row 75 with a value. If D75 was 10 then the result should be 2.
How do I solve this?
B72= 1
C72= 1
D72= 1
E72 = 1
F72= 1
And:
B75 = ""
C75 = ""
D75 = ""
E75= 18
F75= ""
I need a sum of row 72 but only sum if there is a corresponding value in 75. So here the sum would be 1 since there is only one cell in row 75 with a value. If D75 was 10 then the result should be 2.
How do I solve this?