How to sum the minimum values for each Building with other conditions

Question

Hello,&nbsp;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 Tool Status should be "Ready"I want the formula to be in one cell. For example the result of the formula will be 12 based on the below example data.&nbsp;Thank you&nbsp;

sergeibaklan · Answer

Abdulaziz009&nbsp;
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")
)

abdulaziz009 · Answer

SergeiBaklan&nbsp;Thank you for your response. I'm using Excel 2016 which doesn't have the function UNIQUE.

sergeibaklan · Answer

Abdulaziz009&nbsp;
I see. Not sure how to do that with one cell formula on legacy Excel. Will try to dig.

abdulaziz009 · Answer

I appreciate your support

Forum Discussion

How to sum the minimum values for each Building with other conditions

Share

Resources