Sum of cells

  • Thread starter Thread starter Pellechi
  • Start date Start date
P

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
 
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
 
Back
Top