IF Statement, Group Adding, Please help me

  • Thread starter Thread starter Khoalty
  • Start date Start date
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.
 
Thank you Bernard,
You are definitely the Excel Guru and saved me for masses of headaches.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Figuring out a lengthy formula. Probably quite simple... 3
(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O 5
Nested IF Statements 1
Modify range in VBA 9
help on a formula (match and etc..) 1
Array macro question 4
Two Totals from the same column 2
adding rows into the table 1

Back
Top