manipulating values from IF statement

Hi,

I want to pull values from a nested IF statement.

The sheet work like this:

I select a value in cell A2 which displays the associated cost in cell B2, I then want to total the cells in B2 using a simple SUM but am unable to do this, (the value remains at zero).

I am assuming this is because the values are being pulled from the nested IF statement in cell B2.

Is there a way of doing getting the total?

Hope this makes sense?

Thanks

I'm confused as to what you really want. You said you want to total the cells in B2... but B2 IS only one cell. If you could upload a sample spreadsheet with your requirements and expected output/solution, it would be a lot easier to help.

- Moo

It might make more sense if you posted a sample workbook which shows what data and formulae you have and what you are trying to achieve. The FAQ describes how you can attach a file to a post - basically, click on Go Advanced, then either use the paperclip icon or scroll down and click Manage Attachments, and then follow the steps.

Hope this helps.

Pete

Originally Posted by Moo the Dog

I'm confused as to what you really want. You said you want to total the cells in B2... but B2 IS only one cell. If you could upload a sample spreadsheet with your requirements and expected output/solution, it would be a lot easier to help.

- Moo

Thanks for the prompt replies

I have now attached a cut down version of the worksheet so hopefully you will see what I am asking.

You probably should do away with the nested IF formula and go with this: (Put in B2 and fill down)

=IFERROR(VLOOKUP(A2,data!$A$3:$B$21,2,0),"")

- Moo

That is great, could you explain what is happening in that formula?

The IFERROR part checks to see if the result of the formula is an error, and if so, results in a blank cell.

The VLOOKUP tells Excel to look for the value that is in cell A2, and find it on the 'data' sheet (data!$A$3:$B$21) in column A, and return the corresponding value from column B (,2) and only if it is an exact match (,0).

Excel's built-in help system can help you out, too. Also, you can type =VLOOKUP into a cell then hit the Fx button just left of the formula bar, and a Formula Helper will pop up to guide you along the way.

Hope that helps!

- Moo

Thanks for your help, I' sure i will be back!

You're welcome rchapman. Glad I could help!

- Moo

- - - - - - - - - -
If you are satisfied with the solution(s) provided, please mark the thread as [SOLVED] by clicking on the words 'Thread Tools' above your 1st post in this thread. Then select 'Mark Thread as Solved'.

Also, a good way to 'Say thanks' to those who have helped is to click on the star below their name in one of their posts. It's always appreciated.