Thread: extract number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
smonsmo smonsmo is offline
external usenet poster
 
Posts: 20
Default extract number

I have a work sheet that has a number of rows that contain a drop down list.
This list is populated by a number of different criteria. Here's one
example: "Install / Sand and Finish 2 1/4" x 3/4" #1 Red Oak in Living room.
(259.88 sq ft)"
I would like to be able to get a total sq ft of each row that is an
"install". There are times when there would be multiple "installs" and I
need to total these together.
Thanks for the Help