+ Reply to Thread
Results 1 to 4 of 4

Total-sum as per month & year for the amounts

  1. 10-05-2017, 01:35 AM #1
    Ronni1991
    Ronni1991 is offline
    Registered User
    Join Date
    10-04-2017
    Location
    London
    MS-Off Ver
    2016
    Posts
    16

    Post Total-sum as per month & year for the amounts

    TOTAL-SUM AS PER MONTH & YEAR FOR THE AMOUNTS WHEN STATUS CHANGES TO CASH OR DEPOSIT

    =SUM(SUMIF(B6:R6:B11:R11:B16:R16,{"Deposit","Cash"},B3:R3:B8:R8:B13:R13)) ====THIS IS MY FORMULA WORKING FOR ALL the cell total whenever the status is cash or deposit but I want to do this formula with one more criteria as per months and year, THIS FORMULA SHOULD ALSO SPERATE MONTHS AND YEAR THEN ADD IN TOTAL.

    the DATE ROW is A4,A9,A14 BUT THIS DATE ARE NOT FIXED IN CELL IT CAN BE CHANGE IF WE CAN DO SOMETHING WITH RANGES WITH MY FORMULA THEN IT WILL BE MUCH BETTER.

    =SUM(SUMIF(B6:R6:B11:R11:B16:R16,{"Deposit","Cash"},B3:R3:B8:R8:B13:R13))

    PLEASE FIND THE ATTACHEMENT YOU WILL FIND HOW ITS WORKING .

    I TRIED BY BEST TO EXPLAIN EVERYTHING ?
    Attached Images Attached Images
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-05-2017, 01:53 AM #2
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,133

    Re: Total-sum as per month & year for the amounts

    This looks familiar ...???


    /www.excelforum.com/excel-formulas-and-functions/1203370-total-sum-for-months-amounts-using-sumifs-formula.html
    Reply With QuoteRegister To Reply
  3. 10-05-2017, 01:58 AM #3
    Ronni1991
    Ronni1991 is offline
    Registered User
    Join Date
    10-04-2017
    Location
    London
    MS-Off Ver
    2016
    Posts
    16

    Re: Total-sum as per month & year for the amounts

    Quote Originally Posted by JohnTopley View Post
    This looks familiar ...???


    /www.excelforum.com/excel-formulas-and-functions/1203370-total-sum-for-months-amounts-using-sumifs-formula.html
    yes but this is more simplified to understand ....
    Reply With QuoteRegister To Reply
  4. 10-05-2017, 02:08 AM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,924

    Re: Total-sum as per month & year for the amounts

    Ronni, I wish to point out 2 things to you here.

    1. If you need to update your thread, update your ORIGINAL thread, do not keep posting duplicate threads, I have already told you this. If you post another duplicate thread (I have already closed 4, myself), your membership of this forum will be reviewed
    2. Do not create more than 1 ID here, please, stick with the 1st 1 you created
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. total of days within current month with dates from before the current month and year
    By ozinal in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-29-2016, 01:28 PM
  2. [SOLVED] YTD total from beginning of year to last month
    By rs1aj in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-05-2015, 06:16 PM
  3. [SOLVED] Help with formula to give me a total by month and year end for each driver.
    By mhenders00 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-16-2015, 02:00 PM
  4. [SOLVED] How to calculate Year, Month and Day from total number of days?
    By Indra Rai in forum Excel General
    Replies: 4
    Last Post: 06-25-2014, 02:08 PM
  5. how to calculate the total absences within a year per month
    By paularhea09 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-31-2013, 08:32 AM
  6. If Column A Month and Year = ColumnB Todays Month and Year then send email
    By HACCStaff in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-15-2013, 12:47 AM
  7. [SOLVED] worksheet projecting month to year service contract amounts
    By John in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-21-2005, 04:05 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1