Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 28th 09, 01:13 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 3
Default Simple Formula Questions (I hope)

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


  #2   Report Post  
Old May 28th 09, 01:22 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2008
Posts: 793
Default Simple Formula Questions (I hope)

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

  #3   Report Post  
Old May 28th 09, 01:48 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 3
Default Simple Formula Questions (I hope)

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

  #4   Report Post  
Old May 28th 09, 01:54 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2009
Posts: 1,104
Default Simple Formula Questions (I hope)

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



  #5   Report Post  
Old May 28th 09, 02:18 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 3
Default Simple Formula Questions (I hope)

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






  #6   Report Post  
Old May 28th 09, 05:36 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2008
Posts: 793
Default Simple Formula Questions (I hope)

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




Reply
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
Simple problem, simple formula, no FUNCTION ! [email protected] Excel Worksheet Functions 6 September 28th 07 04:51 PM
Simple one I hope???? Kev Excel Discussion (Misc queries) 2 May 10th 07 02:06 PM
Charting - 2 questions simple scale and use of F11 SteveW New Users to Excel 2 July 3rd 06 02:47 PM
Questions should be simple please help babiigirl Excel Worksheet Functions 3 June 14th 06 07:24 PM
Newby questions - simple (I hope) Nooby Excel Discussion (Misc queries) 1 March 8th 06 06:04 PM


All times are GMT +1. The time now is 11:29 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017