View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
HERNAN HERNAN is offline
external usenet poster
 
Posts: 103
Default 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!