Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 7 of 7

Thread: Adding Columns Together

  1. #1
    Join Date
    22nd October 2005
    Posts
    4

    Adding Columns Together

    Hi,

    I know the basics of excel but not much more than that. I need to create a spreadsheet that will calculate the cost of items i wish to sell.

    I need It to add together the item cost, gift cost and give a total. Then add the total to the postage cost and add VAT. So that I can then see the total amount that the item is costing me to work out my sale price.

    Im sure this is a very basic thing to do but not to someone who doesnt know alot about excel!

    You help is much appreciated.
    Joanne
    Last edited by joannestevenson; October 22nd, 2005 at 09:50.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    2nd August 2004
    Location
    Ontario - Canada
    Posts
    1,452

    Re: Beginner - Adding Columns Together

    Oops! Hi and welcome to OzGrid!

    Is VAT calculated before or after the Postage is added in?
    Last edited by Barbarr; October 22nd, 2005 at 10:31. Reason: Welcome Message
    Barbara - aka The Cat Lady

    Please do not U2U (private message) me directly for questions that should be posted to the forum; any such U2Us, unless requested by me, will be deleted.

  3. #3
    Join Date
    2nd August 2004
    Location
    Ontario - Canada
    Posts
    1,452

    Re: Beginner - Adding Columns Together

    And what is the VAT %?
    Barbara - aka The Cat Lady

    Please do not U2U (private message) me directly for questions that should be posted to the forum; any such U2Us, unless requested by me, will be deleted.

  4. #4
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,717

    Re: Beginner - Adding Columns Together

    Hi Joanne

    Welcome to ozgrid

    Please do not include non-keywords (Beginner) in your Thread Titles.

    Your question is too vague to answer with detail, all I can suggest is reading the pages below
    Excel SUM Formula
    Excel Autosum Function
    Pivot Tables

  5. #5
    Join Date
    22nd October 2005
    Posts
    4

    Re: Beginner - Adding Columns Together

    Someone has helped me, ive figured it out!

    Thanks for your help anyway :D

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    2nd August 2004
    Location
    Ontario - Canada
    Posts
    1,452

    Re: Beginner - Adding Columns Together

    Quote Originally Posted by joannestevenson
    Someone has helped me, ive figured it out!

    Thanks for your help anyway :D
    Good to hear!
    Barbara - aka The Cat Lady

    Please do not U2U (private message) me directly for questions that should be posted to the forum; any such U2Us, unless requested by me, will be deleted.

  7. #7
    Join Date
    2nd August 2004
    Location
    Ontario - Canada
    Posts
    1,452

    Re: Adding Columns Together

    I thought the attached might be of interest to you and any others who need help in this area. There are two worksheets: 1 with VAT calculated before Postage and 1 with VAT calculated after Postage.

    The formulas in Columns C, E, F are currently copied to row 15. You can copy them down as far as you want even though there is no Item Cost or Gift Cost entered.

    The formula in column C (Total Cost) uses the COUNTA() function which counts the number of cells that contain data in the referenced range. So unless there is at least 1 cell that contains data, the formula will not calculate.

    The formula in column E (VAT) doesn't calculate if the Total Cost has not calculated. I've used the ISBLANK() function to check is Total Cost is blank. So if VAT is calculated before Postage, the formula is =IF(ISBLANK(C2),"",C2*0.17). Alternatively, I could write the formula
    =IF(C2="","",C2*0.17) or reversing the logic =IF(C2<>"",C2*0.17,"")

    The formula in column F (TOTAL) doesn't calculate if the Total Cost has not calculated. So the formula, regardless of when VAT is calculated, is =IF(ISBLANK(C2),"",SUM(C2,D2,E2)).

    So by ensuring that formulas only calculate when you want, you avoid all those 0s. Alternatively, you could use Excel's Conditional Formatting in Columns C, E, and F so that if the result is 0, the font is white so the 0s don't show. Go to column H on the VAT Before Postage worksheet where I have applied conditional formatting (select the cells and from the menu, Format>Conditional Formatting...). I have entered some numbers but only those <> 0 are shown because of the font colour.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.
    Barbara - aka The Cat Lady

    Please do not U2U (private message) me directly for questions that should be posted to the forum; any such U2Us, unless requested by me, will be deleted.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Adding Columns Within A Pivottable
    By willie447 in forum EXCEL HELP
    Replies: 5
    Last Post: June 21st, 2007, 07:52
  2. Adding two columns of words
    By forumwatcher in forum EXCEL HELP
    Replies: 8
    Last Post: July 28th, 2006, 19:33
  3. Adding two columns
    By wdc202 in forum EXCEL HELP
    Replies: 1
    Last Post: June 27th, 2006, 04:15
  4. adding rows and columns
    By networkmom in forum EXCEL HELP
    Replies: 6
    Last Post: April 16th, 2006, 05:13
  5. adding rows and columns
    By lneilson in forum EXCEL HELP
    Replies: 11
    Last Post: October 31st, 2005, 02:00

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno