View Single Post
  #6 (permalink)  
Old June 10th, 2008, 10:50 PM
stanleydgromjr stanleydgromjr is offline
Authorized User
Points: 193, Level: 3
Points: 193, Level: 3 Points: 193, Level: 3 Points: 193, Level: 3
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2007
Location: North East Pennsylvania, USA.
Posts: 48
Thanks: 0
Thanked 4 Times in 4 Posts
Default

ptrussell2009,

This works in my test environment. I added a blank row at the top of each drop down list.

Try this formula in cell K1 (then copy it down):
=LOOKUP(H1,{0,"xDE","xDV","xO1","xOQ","xOV","xR1", "xRB","xRP","xSB","xTO","xTS"},{0,1,2,3,4,5,6,7,8, 9,10,11})+LOOKUP(I1,{0,1,2,3,4,5},{0,1,2,3,4,5})+L OOKUP(J1,{0,"ITC1","ITC2","PR1","PR2"},{0,1,2,3,4} )

As you change the drop down selections in column H, I, and J, the total will appear in column K, for each row.


Have a great day,
Stan

stanleydgromjr

Windows Vista Business and Excel 2003, 2007.
Reply With Quote