Sumif Function

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

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