LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
stacking multiple column data into a single column Chubby Excel Worksheet Functions 1 January 12th 07 07:24 AM
How do I convert multiple columns to a single column? scottflinders Excel Discussion (Misc queries) 5 November 12th 06 02:13 PM
Single column into multiple columns Heidi Excel Discussion (Misc queries) 3 November 1st 06 09:27 PM
Add single fuction to end of multiple cell column Mead1 Excel Discussion (Misc queries) 2 October 17th 06 04:21 PM
pair single column to multiple column Ross Excel Worksheet Functions 6 June 1st 05 10:23 AM


All times are GMT +1. The time now is 02:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"