journey

  1. F

    Combining IF and SUMIFS: Only getting #NAME? error

    Looking to sum a column of values based on: - Direction of service (options are North, South, Both, based on filter value in cell) - Journey (noted by OD) (starting location and final destination) (options are All or only one, based on filter value in cell) - Start time of journey (options are...
  2. K

    Calculating a mileage allowance

    I'm sure that I'm over complicating. Essentially I need to calculate the amount per journey where the amount is $0.45 per mile for the first 10,000 and $0.25 thereafter. My formula works fine up to 10,000 and for the journey that crosses the threshold but not for amounts over 10,000...
  3. M

    Formula for Per diem (Counting Specific Time and Days).

    Hi everyone, I´m new here and I hope someone can help me. English is not my native language but I have seen a question similar to mine that was posted in 2010. So, I'll give it a try, and if I make mistakes please forgive me :pray: I am trying to generate a travel calculating formula for...
  4. D

    Return valuse that contain a string or two strings

    Hi I have a list of book titles in A1:100. In cell C1 the user enters a string of one word (and, if possible, two words separated by a space*) In cells D1 to D5 I need formulas to return the full book titles that contain the word or words the user has entered. *e.g. if "Journey to the...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top