Thread: formula help
View Single Post
  #2  
Old January 16th, 2009, 11:11 PM posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
  
Posts: 6,167
Default formula help
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!