Re: Sumif Function

Giganews Newsgroups
Subject: Re: Sumif Function
Posted by:  Portuga (Portuga.28ocky_1149083101.8209@excelforum-nospam.com)
Date: Wed, 31 May 2006

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

Considering your sample starts on A1:

Put on cel G1 the following formula:
=IF(B1=6,F1,0)

Column G will now display values only when column B is 6. You can use
column G to get your totals.

--
Portuga
------------------------------------------------------------------------
Portuga's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=6385
View this thread:http://www.excelforum.com/showthread.php?threadid=547083

Replies

None

In response to

Sumif Function posted by Jeff on Wed, 31 May 2006