Excel Formula , if and
 

I have data in 3 columns

A B C
ffaagu 195.00 oct 1 2008
ffaagu 275.00 jan 1 2008
uquwwr 412.00 nov 3 2008
qiwooo 412.00 oct 1 2007
uquwwr 327.99 nov 3 2008

I want to add up the values in column B if the data in Column A and C both
match...
i.e.. uquwwr nov 3, 208 shows match

Excel Formula , if and
 

Let's say your data is in A1:C5
In D1 enter =A1&C1 and copy down the column
In E1 use =COUNTIF($D$1:$D$5,D1) and copy down the column
To sum all that match: =SUMIF(E1:E5,"1",B1:B5)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Bones" wrote in message
...
I have data in 3 columns

A B C
ffaagu 195.00 oct 1 2008
ffaagu 275.00 jan 1 2008
uquwwr 412.00 nov 3 2008
qiwooo 412.00 oct 1 2007
uquwwr 327.99 nov 3 2008

I want to add up the values in column B if the data in Column A and C both
match...
i.e.. uquwwr nov 3, 208 shows match