Results 1 to 2 of 2

Thread: Excel Formulas - add certain fields only

  1. #1

    Excel Formulas - add certain fields only



    Register for a FREE account, and/
    or Log in to avoid these ads!

    hi

    i need to be able to add up figures that were entered in a certain month and cant figure out the formula to do this.

    my sheet is set up like this:

    Sheet1
    Column A Col B
    Date Amount
    12/4/13 45
    15/4/13 60
    27/4/13 150
    2/5/13 30
    5/5/13 80
    5/6/13 75

    Sheet 2 - i need to calculate how much was paid in april, may june etc in the fields below

    Col A Col B Col c etc
    April May June


    can anyone help please






  2. #2
    Wizard Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,504
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Hi
    the easiest and fastest way is to use a Pivot Table and group the dates by month.

Posting Permissions

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