| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Need a formula that sums a column but could exclude some cells
In column F, from F5..F30, I have a set of dollar amounts that I want to sum.
However, if the value in cell K1="no" then I do not want to include in the sum any value in column F that has in the same row the value "House" in column I. Howard |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to identify a keyword in all cells of a column | Excel Discussion (Misc queries) | |||
| Formula for Extracting Month out of a Date column | Excel Discussion (Misc queries) | |||
| Need one formula for large sections of one column, but.... | Excel Discussion (Misc queries) | |||
| column to row in formula | Excel Worksheet Functions | |||
| how to enter a formula using column() function for a range | Excel Worksheet Functions | |||
Threaded Mode
