0

I have a Table that can be filtered by 1 column values, and want to create a cell that calculates the MIN when filter is applied.

Nº cell A B
2 car 2
3 Moto 30
4 Moto 20
5 car 30
6 Moto 4
7 car 10

So I can calcualte min with =MIN(B2:B7) , but I want to create a cell to calculate the min in both cases:

Filtering "car" : B will show cells 2,5 and 7 so MIN= 2

Filtering "moto": B will show cells 3,4,6 so MIN=4

SERGIO
  • 92
  • 6
  • So have you tried minifs() ? you can set one criterion to be "car" or "moto" and then get the min. – Solar Mike Jan 29 '23 at 13:05
  • 1
    [SUBTOTAL](https://support.microsoft.com/en-us/office/subtotal-function-7b027003-f060-4ade-9040-e478765b9939) using `Function_num` 105? – Axel Richter Jan 29 '23 at 13:10

2 Answers2

1

Well, just to show the use of minifs():

enter image description here

=MINIFS(B2:B7,A2:A7,D2)
Solar Mike
  • 7,156
  • 4
  • 17
  • 32
0

Solved with @Axel Ritcher comment

=SUBTOTAL(105;B2:B7)

SERGIO
  • 92
  • 6