IF Statement, Group Adding, Please help me

K

Khoalty

I have a problem in using an If Statement and adding statement
together.

A B C D
Carl 1 2 3
1 2
Luis 1 1 11
Jim 1 1 1


I am trying to make an if statement where if there is anything as in
letters or words in column A, it will add whatever is in cell B and C.
So the 2nd row plus the 3rd row plus the last row will equal to 7.
Since the 3rd row has nothing in column A, it will not add C's value.
I would need the answer in one cell that adds up the whole result to 7.

Thanks for the help.
 
K

Khoalty

Thank you Bernard,
You are definitely the Excel Guru and saved me for masses of headaches.
 
Top