Closed Thread
Results 1 to 3 of 3

how to make formula to add yellow box amount as per dates when the status changes to depos

  1. 10-04-2017, 01:22 AM #1
    prakash24
    prakash24 is offline
    Registered User
    Join Date
    10-02-2017
    Location
    noida
    MS-Off Ver
    2016
    Posts
    102

    Post how to make formula to add yellow box amount as per dates when the status changes to depos

    how to make formula to add yellow box amount as per dates when the status changes to deposit or cash if the date is january then it should add to january blue total and if the date is april then it should add automatically in blue april total ...the dates and amount may change every time in yellow box

    PLEASE FIND THE ATTACHMENT...

    Fix it please.....
    Attached Images Attached Images
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-04-2017, 01:44 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,202

    Re: how to make formula to add yellow box amount as per dates when the status changes to d

    Duplicate post

    http://www.excelforum.com/excel-form...is-deposi.html
    Reply With QuoteRegister To Reply
  3. 10-04-2017, 01:53 AM #3
    FDibbins
    FDibbins is online now
    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,936

    Re: how to make formula to add yellow box amount as per dates when the status changes to d

    Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

    Thread Closed.

    http://www.excelforum.com/excel-form...is-deposi.html
    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
Closed 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. [SOLVED] How to make formula.... If its 1 bedroom appartment and its status is deposit it should su
    By prakash24 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-09-2017, 10:11 AM
  2. [SOLVED] Totalsum as per month,year when status changes
    By prakash24 in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 10-08-2017, 02:10 AM
  3. how to make formula to add yellow box amount add with the same month when status is Deposi
    By prakash24 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-04-2017, 02:28 AM
  4. [SOLVED] Formula between two dates but only show dollar amount if between those dates
    By rhett7660 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-30-2017, 05:31 PM
  5. IF formula with different status dates
    By mbay in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 07-27-2013, 10:26 AM
  6. [SOLVED] How can I add a graphic for Red Yellow Green Status based on a date field?
    By prgates in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-27-2012, 02:45 PM
  7. [SOLVED] Display latest status in Final Status column after comparing the status on three dates
    By shekharnyk in forum Excel General
    Replies: 4
    Last Post: 04-08-2012, 09:43 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