Forum Discussion

Jacemcarty's avatar
Jacemcarty
Copper Contributor
Jun 25, 2023

How do I only add a value if it’s less than another

I’ve been trying to find a formula that will do this but to no avail. I’m trying to have a table with “breakdowns under 15 minutes” and “breakdowns over 15 minutes” but to do that I need to consolidate all the cells that are below and all above 15 minutes. It needs to be a formula that automatically fills it in based on the future information (because this is for next year). Bonus points if I can do this with only one step.

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor

    Jacemcarty 

     

    IMHO you should share:

    • A picture showing a few actuals to allow forum contributors to identify how to group/consolidate your under/over 15 mins
    • Another one showing a couple of expected results

    + cf. Welcome to your Excel discussion space!: Version of Excel in use & OS (Windows, Mac, ...)?

Resources