I think this will work:

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

HTH...

-----Original Message-----
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


.