Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |