CONDITIONAL RESULTS DEPENDING ON CELL'S NAME (sumproduct)

[Guest]

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!

 

[Guest]

What are you calculating?

 

[Guest]

I am sure SUMPRODUCT can work somehow. It seems to be an answer to a lot,
but I am not that comfortable with it. This is what I came up with. Given
that LTV, PMS, PPP, RESULT are in row 1 (A1 - D1) and the rest falls in line
accordingly, the formula that I put in D2 is:

=SUMIF(A1:C1,"=LTV",A2:C2) +SUMIF(A1:C1,"=PPP",A2:C2)

 

[Guest]

if LTV and PPP columns are fixed e.g columns A and C, then

=A2+C2

 

[Guest]

that was beautifull, thank you so much, it looks like its working perfectly,
I'll try it, really thank you