| 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 |
|
#2
|
|||
|
|||
|
try
=if(K1="no",sumproduct(--(I5:I30<"House"),F5:F30),Sum(F5:F30)) "Watercolor artist" wrote: 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 |
|
#3
|
|||
|
|||
|
In "sumproduct(--(" what's the purpose of (--?
Howard "bj" wrote: try =if(K1="no",sumproduct(--(I5:I30<"House"),F5:F30),Sum(F5:F30)) "Watercolor artist" wrote: 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 |
|
#4
|
|||
|
|||
|
Take a look at the following explanation of SUMPRODUCT by Bob Phillips
http://xldynamic.com/source/xld.SUMPRODUCT.html -- Regards Roger Govier "Watercolor artist" wrote in message ... In "sumproduct(--(" what's the purpose of (--? Howard "bj" wrote: try =if(K1="no",sumproduct(--(I5:I30<"House"),F5:F30),Sum(F5:F30)) "Watercolor artist" wrote: 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 |
|
#5
|
|||
|
|||
|
Thanks.
"Watercolor artist" wrote: 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 |
| Reply |
| 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 | |||
Hybrid Mode
