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
Hi,
One way
=IFERROR(MIN((L7:L46)*(L7:L46>0)*(BX7:BX46>0)*(CD7:CD46>0)),"")
Don't forget that since you have XL2007 you can avoid 'doubling up' fomulae in =IF(ISERROR()) function by using the more efficient =IFERROR()
Regards
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks