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