Excel Formula , if and

[Bones]

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

 

[Bernard Liengme]

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