Tricky one here (I think):

I have a drop down list of Labor Periods on a cover sheet.

On a separate data sheet I have:

Period 1 Period 2 ...

Units Cost Hours Units Costs Hours

The oldest Labor Period is the farthest to the right.

I need a formula that will find the Labor Period selected from a drop down

(DV) and sum the values to the right of that Labor Period.

So if Labor Period 5 is selected, I want to add up the hours for Labor

Periods 5,4,3,2,1.

Any help would be lovely.

Beric

I think we need to be told about how you data is set out. Remember, we

cannot see you data and we have no real idea of what the project is. Please

give us more details so we can help

best wishes

--

Bernard Liengme

http://www.yqcomputer.com/

Microsoft Excel MVP

"Beric Dondarrion" < XXXX@XXXXX.COM > wrote in

cannot see you data and we have no real idea of what the project is. Please

give us more details so we can help

best wishes

--

Bernard Liengme

http://www.yqcomputer.com/

Microsoft Excel MVP

"Beric Dondarrion" < XXXX@XXXXX.COM > wrote in

1. Can I SUM column C IF Column A=X AND Column D=Y?

2. SUM/COUNT column(s) based on specific value present within the column => Additional question

3. Counting A's in a table column 1, F's in column 2, etc...

4. "Matching" column A's values in column B

5. how to move columns left when column to the right of columns is hi

6. Tabbing from column to column to column in a 5 column document.

7. How to add previous sums in a column to current sums in a column?

8. Select Sum(table1.column), Sum(table2.column)

9. best way to sum a column with #N/a's?

10. Automatic sum of a column when the other column has the same vaule

11. If column = value sum another column and place result in cell

12. How do I sum #s in a column based on dates in another column

13. sum column and calculate numbers >0 in the same column with 1,5

14. Automatic sum of a column when the other column has the same v

15. SUM values in this column F only if cell is blank in column Q...HE

2 post • Page:**1** of **1**