LOOKUP formula combined with an IF Formula

[Detectiveclem]

Hi can anyone help. I am currently using the following formula to sum to two based on another cell having data (i.e. not blank)

=IF(O20="","",Q19+P20)

This works perfectly well so long as Q19 has data, however this is not always the case and therefore I would prefer to use the LOOKUP formula so that if O20 has data the calculation will be based upon the last no blank cell in Q which then would work.

I have played around with the formula

=LOOKUP(9.99E+307,Q6:Q19) by try to include it with the =IF formula but have been unsuccessful. I would really appreciate some help here.

Thank you

 

[Detectiveclem]

Sorry my last post wasn’t very clear……let me try again

Hi can anyone help. I am currently using the following formula to sum to cells two based on another cell having data (i.e. not blank)

=IF(O20="","",Q19+P20)

This works perfectly well so long as Q19 has data, however this is not always the case and therefore I would prefer to use the LOOKUP formula so that if O20 has data the calculation will be based upon the last non blank cell in Q which then would work.

I have played around with the formula

=LOOKUP(9.99E+307,Q6:Q19) by trying to include the =IF formula but have been unsuccessful. I would really appreciate some help here.

Thank you

 

[Peter_SSs]

Is this what you mean?
=IF(O20="","",LOOKUP(9.99E+307,Q6:Q19)+P20)

 

[Detectiveclem]

Peter you have come to my rescue once again. I play around with it for ages without success. Thank you once again, it's all working perfectly now. Have a great weekend. Paul

 

[Peter_SSs]

Peter you have come to my rescue once again. I play around with it for ages without success. Thank you once again, it's all working perfectly now. Have a great weekend. Paul

Cheers. Glad it worked for you.