Forum Discussion
How to sum the minimum values for each Building with other conditions
Hello, I want to sum the minimum values (Column Capacity) for each Building (column Building) for a certain process while meeting these conditions: The Building Status should be "Ready" the To...
As variant
=SUM(
MINIFS($F$2:$F$8,
$B$2:$B$8, UNIQUE($B$2:$B$8),
$C$2:$C$8, "Ready",
$E$2:$E$8, "Ready")
)
SergeiBaklan Thank you for your response. I'm using Excel 2016 which doesn't have the function UNIQUE.
I see. Not sure how to do that with one cell formula on legacy Excel. Will try to dig.
- I appreciate your support