View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RLR RLR is offline
external usenet poster
 
Posts: 4
Default Multiple a column of costs by a single factor

I have a spread sheet of repair cost for 34 different plan types, each column
is a different plan type of home with repair costs for that plan type in each
column. I want to multiple each column by the number of homes in each of the
plan types. I don't want to enter a formula in each cell of the column (total
of 225 costs per column). There must be a simpler way. Using Excel 2003.