Re: Sumif Function

Giganews Newsgroups
Subject: Re: Sumif Function
Posted by:  al…@melville.ws
Date: 1 Jun 2006

Far as I know, sumif can only check 1 column in its first range...so
what I do is create a new column, where you concatenate your column B &
C...then use that concatenated column as the first range of the sumif

new column G
=B&C

copied down for each row results in:

G
6M
6M
6F
6F
6F

Then use this formula (assuming data starts in row 2)

sumif(G2:G6,"6F",F2:F6)

Based on your data, you get a result of 21,187

Hope this helps

Alan

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

Replies

None

In response to

Sumif Function posted by Jeff on Wed, 31 May 2006