Thread: Sum of cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pellechi Pellechi is offline
external usenet poster
 
Posts: 8
Default 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