| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing
In cell A14, I want to SUM cells A2:A13 and display the higher value of
A2:A13 or cell A1. What would the formula be? FYI..... In practice, if cell A1 has an entry, A2:A13 should not...and vice-versa. However, it case of entries in A1 and some or all of A2:A13 I want to pick the higher value for A1. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| summing values appearing in col B when col A has been filtered | Excel Worksheet Functions | |||
| Summing a Range Omitting the Occasional #N/A | Excel Worksheet Functions | |||
| Summing accross sheets | Excel Worksheet Functions | |||
| Lookup value throughout an array_return adjacent value and summing | Excel Worksheet Functions | |||
| Cumulative Summing | Excel Discussion (Misc queries) | |||
Threaded Mode
