+ Reply to Thread
Results 1 to 8 of 8

Add up the total amount of cash depending on the month?

  1. #1
    Registered User
    Join Date
    04-18-2016
    Location
    Sheffield
    MS-Off Ver
    2010
    Posts
    30

    Add up the total amount of cash depending on the month?

    Hi everyone,

    Is there a way of adding up the total amount of cash depending on the month? For example, I want to know the total amount of cash gained for September, is there a formula that can automatically check which month im looking for and add up all the cash for that month?

    I've attached a sheet which hopefully makes it clearer

    Thank you for any help

    King regards
    Attached Files Attached Files

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    365
    Posts
    6,149

    Re: Add up the total amount of cash depending on the month?

    With a slight amendment to the cells containing months, to make them dates, you could use SUMIFS to do this.

    See attached.

    BSB
    Attached Files Attached Files

  3. #3
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,644

    Re: Add up the total amount of cash depending on the month?

    Hi,

    Make sure the dates in E1:P1 are proper date numbers then use a SUMIFS formula in E2 copied across.

    i.e.

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    See attached
    Attached Files Attached Files
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Registered User
    Join Date
    04-18-2016
    Location
    Sheffield
    MS-Off Ver
    2010
    Posts
    30

    Re: Add up the total amount of cash depending on the month?

    Thank you very much BSB and Richard! Very kind of you both. could I ask a big favour? im not great with excel formula so I was just wondering if you could breifley explain what some of the formula bits mean?

    =SUMIFS($B:$B,$A:$A,">="&E1,$A:$A,"<="&EOMONTH(E1,0))

    I understand 3/4 of it but im not sure what "&EOMONTH(E1,0))" is?

    Thanks again for all your help

  5. #5
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    365
    Posts
    6,149

    Re: Add up the total amount of cash depending on the month?

    EOMONTH is "End Of Month"

    It takes the date from a specified cell (in this case E1) and tells you what the last day of the month is the number of months onward specified by the last argument. In this case 0 months.
    I use it to make 28/29/30/31 days in a month less hassle.

    So EOMONTH(E1,0) is saying what's the last day of the month of the date in E1, zero months on. As E1 holds Sept-15, the result would be 30th Sept 2015.
    EOMONTH(E1,1) would give you the result 31st Oct 2015.

    So the whole formula says, sum the values in column B where column A holds values greater than or equal to 1st Sept 2015 and less than or equal to 30th Sept 2015.

    Hope that makes sense....

    BSB

  6. #6
    Forum Contributor Toonies's Avatar
    Join Date
    07-30-2009
    Location
    Newcastle, UK
    MS-Off Ver
    Excel 2016
    Posts
    491

    Re: Add up the total amount of cash depending on the month?

    Hi try this

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    04-18-2016
    Location
    Sheffield
    MS-Off Ver
    2010
    Posts
    30

    Re: Add up the total amount of cash depending on the month?

    Ah okay that makes more sense now.

    Thanks for your help BSB ive added reputation and marked this thread as solved

    Kind regards
    Matt

  8. #8
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    365
    Posts
    6,149

    Re: Add up the total amount of cash depending on the month?

    Happy to help. Thanks for the rep point

    BSB

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Summarize total amount with different month
    By umininnel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-27-2015, 08:28 PM
  2. Total amount if month is januari
    By Octonet in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-18-2015, 11:09 AM
  3. Total amount is month is januari
    By Octonet in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-16-2015, 07:53 PM
  4. Replies: 5
    Last Post: 05-08-2014, 10:42 AM
  5. [SOLVED] Month-end cash balance from the running cash balances
    By dache416 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-06-2014, 08:06 AM
  6. I am trying to get total amount by month
    By amm_manaz in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-06-2014, 11:54 AM
  7. [SOLVED] Returning total amount earned in a month by day of the week
    By klowned in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-02-2012, 01:03 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1