Hi guys I hope this is simple. I have had a hunt around as I'm sure it has
been answered before but my search concept is off the mark...

Anyway I'm putting together a spreadsheet to work as an order from for about
220 people to order a variety of merchandise (for work) and I want excel to
do the maths on order numbers and costs for me.

At the moment I have the following formula doing what I want:

C13=PRODUCT(B13*B11)

Unfortunately though B13 goes all the way through to B224. Is there a way
without individually doing each cell that I can automatically make it become
D13=PRODUCT(D13*B11), E13=PRODUCT(E13*B11) etc.

Similarly I have a another formula X13=SUM(C13,E13,
G13,I13,K13,M13,O13,Q13,S13,U13,W13,Y13) is there a way to automatically make
this apply across individual rows all the way to 224 without doing it
individually? so it would become X14=SUM(C14,E14,
G14,I14,K14,M14,O14,Q14,S14,U14,W14,Y14) etc.

These are probably the simplest questions you've had for a while but at the
moment I look like I'm doing each formula individually ... I'm sure that
can't be the only option.

Thanks in advance.

Jas

Try in C13
=PRODUCT(B13*$B11)
and copy across to D13,E13....

Second one can be copied down as it is

"Logues" wrote:

Hi guys I hope this is simple. I have had a hunt around as I'm sure it has
been answered before but my search concept is off the mark...

Anyway I'm putting together a spreadsheet to work as an order from for about
220 people to order a variety of merchandise (for work) and I want excel to
do the maths on order numbers and costs for me.

At the moment I have the following formula doing what I want:

C13=PRODUCT(B13*B11)

Unfortunately though B13 goes all the way through to B224. Is there a way
without individually doing each cell that I can automatically make it become
D13=PRODUCT(D13*B11), E13=PRODUCT(E13*B11) etc.

Similarly I have a another formula X13=SUM(C13,E13,
G13,I13,K13,M13,O13,Q13,S13,U13,W13,Y13) is there a way to automatically make
this apply across individual rows all the way to 224 without doing it
individually? so it would become X14=SUM(C14,E14,
G14,I14,K14,M14,O14,Q14,S14,U14,W14,Y14) etc.

These are probably the simplest questions you've had for a while but at the
moment I look like I'm doing each formula individually ... I'm sure that
can't be the only option.

Thanks in advance.

Jas

Thanks

Sum formula sorted as per advice below.

I've adjusted the Product one as you suggest but when I drag it down Column
C I get an Error in C14. I realised that that is becasue I'm an idiot and
what I actually want is:

C13=PRODUCT(B13*B11) to become C14=PRODUCT(B14*B11), C15=PRODUCT(B15*B11) etc.

Sorry ... got my columns and rows mixed up

Jas

"Sheeloo" wrote:

Try in C13
=PRODUCT(B13*$B11)
and copy across to D13,E13....

Second one can be copied down as it is

"Logues" wrote:

Hi guys I hope this is simple. I have had a hunt around as I'm sure it has
been answered before but my search concept is off the mark...

Anyway I'm putting together a spreadsheet to work as an order from for about
220 people to order a variety of merchandise (for work) and I want excel to
do the maths on order numbers and costs for me.

At the moment I have the following formula doing what I want:

C13=PRODUCT(B13*B11)

Unfortunately though B13 goes all the way through to B224. Is there a way
without individually doing each cell that I can automatically make it become
D13=PRODUCT(D13*B11), E13=PRODUCT(E13*B11) etc.

Similarly I have a another formula X13=SUM(C13,E13,
G13,I13,K13,M13,O13,Q13,S13,U13,W13,Y13) is there a way to automatically make
this apply across individual rows all the way to 224 without doing it
individually? so it would become X14=SUM(C14,E14,
G14,I14,K14,M14,O14,Q14,S14,U14,W14,Y14) etc.

These are probably the simplest questions you've had for a while but at the
moment I look like I'm doing each formula individually ... I'm sure that
can't be the only option.

Thanks in advance.

Jas

Why are you using PRODUCT with the multiplication operator ?
I sometimes wear a belt and braces but one would do! <gr
Either =PRODUCT(B13, $B$11)
or just = B13*$B$11
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Logues" wrote in message
...
Thanks

Sum formula sorted as per advice below.

I've adjusted the Product one as you suggest but when I drag it down
Column
C I get an Error in C14. I realised that that is becasue I'm an idiot and
what I actually want is:

C13=PRODUCT(B13*B11) to become C14=PRODUCT(B14*B11), C15=PRODUCT(B15*B11)
etc.

Sorry ... got my columns and rows mixed up

Jas

"Sheeloo" wrote:

Try in C13
=PRODUCT(B13*$B11)
and copy across to D13,E13....

Second one can be copied down as it is

"Logues" wrote:

Hi guys I hope this is simple. I have had a hunt around as I'm sure it
has
been answered before but my search concept is off the mark...

Anyway I'm putting together a spreadsheet to work as an order from for
about
220 people to order a variety of merchandise (for work) and I want
excel to
do the maths on order numbers and costs for me.

At the moment I have the following formula doing what I want:

C13=PRODUCT(B13*B11)

Unfortunately though B13 goes all the way through to B224. Is there a
way
without individually doing each cell that I can automatically make it
become
D13=PRODUCT(D13*B11), E13=PRODUCT(E13*B11) etc.

Similarly I have a another formula X13=SUM(C13,E13,
G13,I13,K13,M13,O13,Q13,S13,U13,W13,Y13) is there a way to
automatically make
this apply across individual rows all the way to 224 without doing it
individually? so it would become X14=SUM(C14,E14,
G14,I14,K14,M14,O14,Q14,S14,U14,W14,Y14) etc.

These are probably the simplest questions you've had for a while but at
the
moment I look like I'm doing each formula individually ... I'm sure
that
can't be the only option.

Thanks in advance.

Jas

Redundancy? ;)

Thanks very much for your help it works.

Jas

"Bernard Liengme" wrote:

Why are you using PRODUCT with the multiplication operator ?
I sometimes wear a belt and braces but one would do! <gr
Either =PRODUCT(B13, $B$11)
or just = B13*$B$11
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Logues" wrote in message
...
Thanks

Sum formula sorted as per advice below.

I've adjusted the Product one as you suggest but when I drag it down
Column
C I get an Error in C14. I realised that that is becasue I'm an idiot and
what I actually want is:

C13=PRODUCT(B13*B11) to become C14=PRODUCT(B14*B11), C15=PRODUCT(B15*B11)
etc.

Sorry ... got my columns and rows mixed up

Jas

"Sheeloo" wrote:

Try in C13
=PRODUCT(B13*$B11)
and copy across to D13,E13....

Second one can be copied down as it is

"Logues" wrote:

Hi guys I hope this is simple. I have had a hunt around as I'm sure it
has
been answered before but my search concept is off the mark...

Anyway I'm putting together a spreadsheet to work as an order from for
about
220 people to order a variety of merchandise (for work) and I want
excel to
do the maths on order numbers and costs for me.

At the moment I have the following formula doing what I want:

C13=PRODUCT(B13*B11)

Unfortunately though B13 goes all the way through to B224. Is there a
way
without individually doing each cell that I can automatically make it
become
D13=PRODUCT(D13*B11), E13=PRODUCT(E13*B11) etc.

Similarly I have a another formula X13=SUM(C13,E13,
G13,I13,K13,M13,O13,Q13,S13,U13,W13,Y13) is there a way to
automatically make
this apply across individual rows all the way to 224 without doing it
individually? so it would become X14=SUM(C14,E14,
G14,I14,K14,M14,O14,Q14,S14,U14,W14,Y14) etc.

These are probably the simplest questions you've had for a while but at
the
moment I look like I'm doing each formula individually ... I'm sure
that
can't be the only option.

Thanks in advance.

Jas

Nobody is an idiot... I don't know Spanish, French, Mandarin etc etc, that
does not make me an idiot :-)

You got your solution from Bernard.

Pl. remember that if you have a $ in front of the letter (Column) and/or
number (row number) then that part of the formula does NOT change when you
copy across or down...

If there is no $ then letter changes (column) when dragged/copied right and
number (row) changes when dragged/copied down.

"Logues" wrote:

Thanks

Sum formula sorted as per advice below.

I've adjusted the Product one as you suggest but when I drag it down Column
C I get an Error in C14. I realised that that is becasue I'm an idiot and
what I actually want is:

C13=PRODUCT(B13*B11) to become C14=PRODUCT(B14*B11), C15=PRODUCT(B15*B11) etc.

Sorry ... got my columns and rows mixed up

Jas