Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
If I have 1 row with 5 columns of data, how do I conditionally sum the
columns based on whether the column is greater than a value in another separate cell? For example, A B C D E 5 32 16 22 6 89 6 7 3 I only want to sum A5:E5 if the column is greater than the contents of A7. In this example, the answer would be (6+89)=95. If A7=1, then the answer would be (16+22+6+89)=133. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Columns | Excel Discussion (Misc queries) | |||
How do I Double Conditional vlookup for 3 columns? | Excel Worksheet Functions | |||
EXCEL 2003: Apply Conditional Formatting to COLUMNS | Excel Worksheet Functions | |||
Conditional Format ... Compare Columns? | Excel Discussion (Misc queries) | |||
conditional formating of group of columns and rows | Excel Worksheet Functions |