Forum Discussion
Jacemcarty
Jun 25, 2023Copper Contributor
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.
- LorenzoSilver Contributor
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, ...)?