Multiplying one cell by a column

  • Thread starter Thread starter Chrj15
  • Start date Start date
C

Chrj15

I'm trying to multiply column B3:12 by cell W5. B3:12 contains a set number
and I'm trying to multiply that number by the formula result in W5. I've
tried every special paste option and combo. Also W5 is connected to a
spinner. I need B3:12 to adjust as W5 does. So far I've had to manually
link all the cells to W5. Uggh.
Any help appreciated.
 
In C3 enter =B3 * W5

Drag/copy down to B12


Gord Dibben MS Excel MVP
 
Doing this causes the next cell to multiply by W6, and the next by W7...so
on.....
 
you just saved me so much time.....thanks a bunch....wont forget that trick
 
Apologies for not adding the $ signs to W5.

I see Tyro has made the correction.


Gord
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I count the cells ending with a specific letter? 5
average cells 9
Auto fill drop down stops at second cell 2
I WANT TO CREATE A FORMULA USING DATES 8
concatenated text to formula 6
VBA Macro 2
Hide columns based on related cell 4
Paste Special Formula Multiply feature doesn't work anymore 2

Back
Top