Re: Sumif Function

Giganews Newsgroups
Subject: Re: Sumif Function
Posted by:  Andy
Date: Wed, 31 May 2006

Hi

Try this:
=SUMPRODUCT(--(B2:B100=6),--(C2:C100="F"),--(F2:F100))

Andy.

"Jeff" <Je…@discussions.microsoft.com> wrote in message
news:5158BD25-8803-4F66-A6B5-C710C794B2…@microsoft.com...
> 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

Replies

In response to

Sumif Function posted by Jeff on Wed, 31 May 2006