Need a formula that sums a column but could exclude some cells

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

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

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

Take a look at the following explanation of SUMPRODUCT by Bob Phillips
http://xldynamic.com/source/xld.SUMPRODUCT.html

--
Regards

Roger Govier


"Watercolor artist" <[email protected]> wrote in
message news:[email protected]...
> 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

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

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

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

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

Take a look at the following explanation of SUMPRODUCT by Bob Phillips
http://xldynamic.com/source/xld.SUMPRODUCT.html

--
Regards

Roger Govier


"Watercolor artist" <[email protected]> wrote in
message news:[email protected]...
> 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