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

"Ron de Bruin" wrote in message
...
Try this

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

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Pellechi" wrote in message
et...
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