I currently use this formula to find the sum of L7:L46 range when the other criteria is met. I would like to find the min value in L7:L46 range using the same criteria.
=IF(ISERROR(SUMIFS(L7:L46,L7:L46,">0",BX7:BX46,">0",CD7:CD46,">0")),"",((SUMIFS(L7:L46,L7:L46,">0",BX7:BX46,">0",CD7:CD46,">0"))))
Thanks
Bookmarks