Re: Sumif Function

Giganews Newsgroups
Subject: Re: Sumif Function
Posted by:  Dave Peterson (peters…@verizonXSPAM.net)
Date: Wed, 31 May 2006

=sumproduct(--(b1:b999=6),--(c1:c999="f"),(f1:f999))

Adjust the ranges to match--but you can't use whole columns.

=sumproduct() likes to work with numbers.  The -- stuff changes trues and falses
to 1's and 0's.

Bob Phillips explains =sumproduct() in much more detail here:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

And J.E. McGimpsey has some notes at:
http://mcgimpsey.com/excel/formulae/doubleneg.html

Jeff wrote:
>
> Hello,
>
> I need help on a Sumif Function:
> I need to Sumif the values in column F if and only if column B has "6" and
> column C has "F"
> Here's an example:
>
> A      B      C      D      E        F
> 54      6      M      Q      SptAcc  45
> 75      6      M      E      Escada  13
> 1      6      F      1      MEscada          761
> 9      6      F      E      Escada  20,091
> 9      6      F      H      Accessory        335
>
> --
> Regards,
> Jeff

--

Dave Peterson

Replies

None

In response to

Sumif Function posted by Jeff on Wed, 31 May 2006