+ Reply to Thread
Results 1 to 5 of 5

Auto Calculate based on the multiple conditions including date range

  1. #1
    Registered User
    Join Date
    03-20-2020
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    3

    Auto Calculate based on the multiple conditions including date range

    Hi,

    Hope someone here would be able to help.

    I am working on automating benefits calculations for each financial year depending on the release date (which may change from time to time). Have tried numbers of ways using Index/Match, vlookup but struggling to get anything to work. I am attaching a dummy file with data and desired results I want. Please feel free to ask if anything is unclear.

    Thanks in advance!!!

    Regards, Punit.
    Attached Files Attached Files
    Last edited by PunitA; 03-20-2020 at 04:51 PM.

  2. #2
    Forum Expert
    Join Date
    09-25-2015
    Location
    Milan Italy
    MS-Off Ver
    office 365
    Posts
    1,775

    Re: Auto Calculate based on the multiple conditions including date range

    Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

  3. #3
    Registered User
    Join Date
    03-20-2020
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    3

    Re: Auto Calculate based on the multiple conditions including date range

    Hi Caracalla,

    Thanks for your prompt response and guidance. I have just managed to upload a sample file.

    Thanks, Punit.

  4. #4
    Registered User
    Join Date
    03-20-2020
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    3

    Re: Auto Calculate based on the multiple conditions including date range

    Any one here can help with this?

    Thanks a lot in advance!!

    Punit

  5. #5
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,420

    Re: Auto Calculate based on the multiple conditions including date range

    The following produces the same values as those listed in cells C24:C33
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. [SOLVED] Formula to Calculate Payment Date based on Multiple Conditions
    By NonStopLeo in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-18-2018, 01:13 AM
  2. [SOLVED] Count and sum with multiple criteria including date range
    By Perk1961 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-23-2016, 04:46 PM
  3. [SOLVED] Sum every other row with multiple conditions including date less than
    By kingsHorses in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-19-2014, 08:44 PM
  4. [SOLVED] INDEX MATCH based on 5 criteria, including a date range.
    By Folshot in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-05-2013, 09:35 PM
  5. [SOLVED] Count based on 3 criteria including date range
    By timarcarze in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 06-13-2013, 01:43 AM
  6. Date Range Count based on multiple conditions
    By Baka Jaimito in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-27-2011, 11:43 AM
  7. multiple lookup including date range
    By JonWadey in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-12-2007, 09:21 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1