Hello, I'm not quite sure where to go with this... I'm trying to work out the maximum lead time, but only if an item is required (greater than 0 in "quantity"). I've tried, but I know I've got the first part wrong - I'm not sure what command to use!!
So the result should be "10" (the lead time for the window, which is the the longest that is being used), as there are no "blinds" (with a longer lead time) required.
Cheers
Ric
MacBook Pro 15″, macOS 12.7
=MAXIFS(C,A,">0")
Using "entire column" addressing (i.e., A vs A2:A5) captures the entire column without having to adjust the formula/ranges when you add new rows.
=MAXIFS(C,A,">0")
Using "entire column" addressing (i.e., A vs A2:A5) captures the entire column without having to adjust the formula/ranges when you add new rows.
Richard,
Badunit nailed the expression for the calculation. I thought I'd add that you can simplify things a little if you consolidate the two tables into one and use Header and Footer Rows.
Here's the example with your data:
Regards,
Jerry
True. The formula I provided was in a cell in the same table, thus the lack of the table name in the cell references. In another table it would require the table name to be part of the references
perfect, thanks Badunit!!
cheers Jerry, really helpful....!
find a maximum number if value is > 0
