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!

CONDITIONAL RESULTS DEPENDING ON CELL'S NAME (sumproduct)
 

What are you calculating?
--
Brevity is the soul of wit.


"HERNAN" wrote:

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!

CONDITIONAL RESULTS DEPENDING ON CELL'S NAME (sumproduct)
 

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)



"HERNAN" wrote:

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!

CONDITIONAL RESULTS DEPENDING ON CELL'S NAME (sumproduct)
 

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

=A2+C2

"WLMPilot" wrote:

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)



"HERNAN" wrote:

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!

CONDITIONAL RESULTS DEPENDING ON CELL'S NAME (sumproduct)
 

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

"WLMPilot" wrote:

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)



"HERNAN" wrote:

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!