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

Copper Contributor

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.

1 Reply



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, ...)?