| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
| compare 2 column cells and return the adjacent columns cells data of the cell | Excel Worksheet Functions | |||
| join data in multiple cells when adjoining cells match criteria ?? | Excel Worksheet Functions | |||
| Cells won't change font color or show hi-lighted cells in document | Excel Discussion (Misc queries) | |||
| display a range of cells editible cells based on matching date | Excel Worksheet Functions | |||
Linear Mode
