Sum of cells
 

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

Sum of cells
 

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


.

Sum of cells
 

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

Sum of cells
 

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