Announcement

Collapse
No announcement yet.

Adding Columns Together

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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, 08:50.

  • #2
    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, 09: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.

    Comment


    • #3
      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.

      Comment


      • #4
        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

        Comment


        • #5
          Re: Beginner - Adding Columns Together

          Someone has helped me, ive figured it out!

          Thanks for your help anyway :D

          Comment


          • #6
            Re: Beginner - Adding Columns Together

            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.

            Comment


            • #7


              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
              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.

              Comment

              Working...
              X