Sum of cells

[Pellechi]

To All,

I have a formula in cell F76 ... I'm trying to sum 4 cells ...
=SUM(F72:F75)

with 1 caveat ...

2 of the cells (F74:F75) need to be summed first ... and if the total is ">
= 2" then the max value should be 2 ...

Then that is added to the SUM(F72:F73) for a total ...

Can someone guide me ...

Thanks JimP

 

[MacroMan]

I think this will work:

=IF(F74+F75>=2, SUM(F72:F73)+2, SUM(F72:F75))

HTH...

 

[Ron de Bruin]

Try this

=IF(SUM(F74:F75)>2,2,SUM(F72:F73))

 

[Pellechi]

Ron and HTH,

Tried both - didn't work as expected ...
I saw what you did and reworked it ... the following worked ...

=SUM(F72:F73)+SUM(IF(SUM(F74:F75)>2,2,SUM(F74:F75)))

Thanks for setting me on the path ...

JimP