Thank you so much for your help!
i actually needed to total the columns. I rec'd my anser from another post

"Don Guillett" wrote:

You probably meant
=if(a2=D2,b2+c2,"")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Araseli" wrote in message
news
hello,
I have
A B C B E
1 c 100 90 c
2 c 100 100 b
3 d 200 80 f
4 d 100 90 d
total

I need a formula that will add column B and column C only if columns A &
B
are the same.

Thanks!