| View previous topic :: View next topic |
| Author |
Message |
ekcrawford
General User
Joined: 03 Dec 2008
Posts: 5
|
 Posted: Sat Jan 22, 2011 6:02 pm Post subject: Sheets and formulas |
 |
|
I am newer to spreadsheets. I am trying to create a standard bid sheet for my painting business using various sheets. All my prices are based on square foot of wall space. So on one on sheet I want to be able to list dimensions of rooms (height, length, width) multiple by certain prices per square foot (ie: 0.5 or 0.75...etc) to get a price per room -- but I want that to come out on another sheet that will arrange it and only give the name of the room and the price - not all the formulas. Then I can simply create a PDF (which i know how to do) and email to customer.
SO (1) how can I reference the sheet and cell(s) to bring over that price into the estimate form on a second sheet that I am creating for the customer... - both the name of room and the price for each room (2) How do I layout the second sheet to hide all the row and column lines - I know this has to be simple, and used to be able to do it on Excel, but can't figure it out in open office calc....
THNX for any and all help:) |
|
| Back to top |
|
 |
ozzie
OOo Advocate
Joined: 29 Jul 2010
Posts: 316
Location: victoria
|
| Posted: Sat Jan 22, 2011 6:59 pm Post subject: |
|
|
on your estimate sheet,
click the cell where you require the price or whatever
type =
without doing anything else
go to your calculation sheet and click the cell where your info is
press enter
your estimate sheet will now show the info with a background formula that looks like this
don't be afraid to play around with it and add $ signs for absolute referencing if necessary
question2 view -> column & row headers - untick
------------------
if this has answered your question please add "[Solved]" to the beginning of your first post title (edit button), that would save the busy people from looking in and perhaps interest learners like myself who are always looking for answers . |
|
| Back to top |
|
|
ekcrawford
General User
Joined: 03 Dec 2008
Posts: 5
|
| Posted: Sat Feb 05, 2011 3:18 pm Post subject: thanks |
|
|
| i will fool around with your suggestions and see what it does. THNX |
|
| Back to top |
|
|
ekcrawford
General User
Joined: 03 Dec 2008
Posts: 5
|
| Posted: Sat Feb 05, 2011 3:30 pm Post subject: adding entire rows and columns |
|
|
| I did what you did, worked great for referencing one cell. But what if i want to add up entire column or row and have that calculated on another sheet. I did what you said and tried to apply it to entire row... formula then looked like =sheet1.A1:Z1 BUT it only gave me the number in A1... it did not add up all the numbers in the row from A to Z... tried adjusting formula to =sheet1.SUM(A1:Z1) BUT only got an error.... What am I missing? |
|
| Back to top |
|
|
Ed
Super User
Joined: 28 May 2003
Posts: 1040
|
| Posted: Sat Feb 05, 2011 3:39 pm Post subject: Re: adding entire rows and columns |
|
|
| ekcrawford wrote: | | I did what you did, worked great for referencing one cell. But what if i want to add up entire column or row and have that calculated on another sheet. I did what you said and tried to apply it to entire row... formula then looked like =sheet1.A1:Z1 BUT it only gave me the number in A1... it did not add up all the numbers in the row from A to Z... tried adjusting formula to =sheet1.SUM(A1:Z1) BUT only got an error.... What am I missing? |
The sheet name needs to be in front of the cell coordinates. |
|
| Back to top |
|
|
ozzie
OOo Advocate
Joined: 29 Jul 2010
Posts: 316
Location: victoria
|
|
| Back to top |
|
|
|
