How to get specific information contained in one celll....

Hi All,

I am trying to get some information contained in a cell on a seperate sheet and put it in another sheet.

Basically the cell with the information is a drop down. When I select a specific text from the list, I want it to be displayed in another cell with a value indicated in another cell.

For example,

A2 = Incidental
B3 = 2
A3 = Incidental
B4 = 4

If a2:a10 = Incidental, then take sum of b3:b10 and put it in sheet x, A1

Hope that helps.

Thank you everybody.

Newb

Try this:

=SUMIF(Sheet1!A2:A10,"Incidental",Sheet1!B2:B10)

Hope this helps.

Pete

Hi All,

The formula worked however, it did not pull in the sum. It only pulled the first number. Is there a way to incorporate a formula to get the sum?

Thanks,
Newb

Hi Newb,

Pete has the right formula...

Make sure the word "Incidental" is spelled correctly and without extra spaces... my press F9 to calculate.

Good luck,
Dennis

Hi All,

Please see link to workbook.
https://www.yousendit.com/directDown...experience=bas

You all are wonderful. Thank you

Newb

I just found out how to attach this file on this forum.

CDemo.xlsm

Thanks again,

Newb

Unfortunately, I can't do that as it adds to the functionality for the add and delete buttons. Is there any way around this?

Thanks,
Newb

Hi newbie,

Here's a solution...
=SUM((Action_Items!$B$7:$B$34="Incidental_Approved")*Action_Items!$E$7:$E$34)+SUM((Action_Items!$B$7:$B$34="Incidental_Approved")*Action_Items!$E$8:$E$35)

Copy this one big formula in A2 then instead of just Enter... press Control-Shift-Enter...

Notice the Column E are "slightly" off in the 2 sum functions to capture both...

Let me know if you have any questions.

Take care,
Dennis

I think this will work too... without the Ctrl-Shift-Enter...

=SUMIF(Action_Items!$B$7:$B$34,"Incidental_Approved",Action_Items!$E$7:$E$34)+SUMIF(Action_Items!$B$7:$B$34,"Incidental_Approved",Action_Items!$E$8:$E$35)

Hello All,

Thank you so much for your help, but I am still having trouble with the formula. The problem is when I click the add button, it inserts a row and when I input a value there, it doesn't add that into the formula. I will need to find a way around this and it is very odd that the total sum doesn't pick up the additional inserted rows.

Is there any way around this?

Newb

Hi Dennis,

Thank you so much for helping me with this problem. Is there anyway to create a code that says if a person clicks on add button, it will auto populate the type in column b from column c?

Thanks,
Newb

Look at my simple code... it should give you an idea... I wanted to add the formula, so I put quotes around the formula... otherwise, for numbers, don't include the quotes... sorry, it's pretty basic, I'm no VBA expert...

You might want to ask in a different thread in the VBA forum...