CONDITIONAL RESULTS DEPENDING ON CELL'S NAME (sumproduct)
I have this scenario:
LTV PBS PPP RESULT
2 8 5 7
2 8 5 7
I need a formula that calculates ONLY if on the 1st row it says: "ltv" AND
ALSO "PPP". So in this case the result would be 7.
I was trying with =SUMPRODUCT formula but I can't make it work
Please any help will be very welcome!
|