Forum Discussion
Abdulaziz009
Jun 13, 2024Copper Contributor
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...
Abdulaziz009
Jun 13, 2024Copper Contributor
SergeiBaklan Thank you for your response. I'm using Excel 2016 which doesn't have the function UNIQUE.
SergeiBaklan
Jun 13, 2024Diamond Contributor
I see. Not sure how to do that with one cell formula on legacy Excel. Will try to dig.
- Abdulaziz009Jun 13, 2024Copper ContributorI appreciate your support