range of cells

chris2727272727

Board Regular
Joined
Jul 10, 2005
Messages
152
sshirt = 3
item3 = Range("h27:h30").Value * sshirt

only one cell in the above range will have a value i need that value to be * by sshirt
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

RalphA

Well-known Member
Joined
May 14, 2003
Messages
3,829
If you want a formula for this, try, with the desired value placed in cell I26, and the value of sshirt placed in cell I25: =SUMIF(H27:H30.I26)*I25
 

Watch MrExcel Video

Forum statistics

Threads
1,118,435
Messages
5,572,085
Members
412,441
Latest member
kelethymos
Top