applying formula to the entire column

[stunbradfordlgb]

i know this is probably a really simple question for many of you but formulas really escape me haha....

what i want to do is create a spreadsheet that will tell me the profit of my sales against my cost prices.....all i can find online is how to do the profit margin but what i want is to apply the formula to the entire column.....for example.....if the cost price is column a and sale price is in b then i want c to tell me the profit i can do it for individual rows but is there a simple way to apply this to all cells in that column

thank you in advance

[FDibbins]

All you needed to do was change the tittle on your other post, you didnt need to start a new 1 - I will close the other 1 for you

try this...

=sum(C2:C200)-sum(B2:B200)

[stunbradfordlgb]

thank you.....i tried to edit the post but it wouldnt let me edit the title.....ill try that and let you know what happens! :-)

[FDibbins]

To change a Title on your post, click EDIT on you're 1st post, then Go Advanced and change your title

[stunbradfordlgb]

so i tried that and then tried to enter the values of the row before but it just added that sum into the cell in the row above

[FDibbins]

My understanding was that you wanted to total the costs on column B, total the sales in C and then use those 2 totals to calc your profit?

If thats not what you wanted, I would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[stunbradfordlgb]

Untitled.jpgfor example i want each row which is an individual item to have an individual profit so how do i apply this to the profit column so that i dont have to manual do it for each row i can then total it up at the very end of the spreadshett.....is this clear enough???? i dont know the correct way to describe what I want as im not computor minded if im honest but i am appreciating your help

[FDibbins]

Sorry, I dont see any sample workbook, and I cant work with pictures?

[stunbradfordlgb]

sample.xlsx
is this what you want?

[FDibbins]

Thank you

Did you mean in E2, copied down...
=C2-D2

[stunbradfordlgb]

but that only applies it to cell e2 i want to apply it to all cells in the e column but for the row that it corresponds with so e3 will have the profit for c3 and d3, e4 will be c4 and d4...................does that make sense.....i know what i want to do but dont seem to be getting that accorss very well

[Ursul]

Select cell E4 and you will see a small, black 'square' at the bottom right-hand corner of the cell. Double-click (left mouse button) and the formula will 'fill down' to cell E8.

[stunbradfordlgb]

Yay we got there! I have sat and inputted all my data and it works perfectly.....thankyou for your time....and to top it all off after i did my totals in the end i found out that my business is also in profit....not bad going after its first week!

[FDibbins]

Im happy you solved your question, maybe you missed this part?

Thank you

Did you mean in E2, copied down...
=C2-D2

and congrats with your profit

If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)