+ Reply to Thread
Results 1 to 1 of 1

If formula between dates with multiple criteria

  1. #1
    Registered User
    Join Date
    02-28-2011
    Location
    Bournemouth, England
    MS-Off Ver
    Excel 2010
    Posts
    16

    If formula between dates with multiple criteria

    In the attached spreadsheet on the 'reporting' sheet I need to enter a formula in column M13-24 which will return the totals from 'data' column M or column N between the date ranges on 'reporting' column D.

    The differential being that if the cumulative miles in 'data' column L are more than 10,000 for the existing tax year on 'reporting' then column N on 'data' should be used but only from the miles in excess of 10,000. All miles prior to the 10,000 should be calculated using column M on 'data'

    Any help you can give is greatly appreciated.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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