Home 
Search 
Today's Posts 
#1




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




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




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




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




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




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 
Display Modes  


Similar Threads  
Thread  Forum  
Simple problem, simple formula, no FUNCTION !  Excel Worksheet Functions  
Simple one I hope????  Excel Discussion (Misc queries)  
Charting  2 questions simple scale and use of F11  New Users to Excel  
Questions should be simple please help  Excel Worksheet Functions  
Newby questions  simple (I hope)  Excel Discussion (Misc queries) 