Forum Discussion
Excel Formula Help
Hello, I need assistance with an Excel formula, please. I've been struggling with this for hours; your help is greatly appreciated. I have a spreadsheet with 3 columns. The three columns ar...
Hi
the easy way would be a pivot table. "Year" and "Month" in row area and "Amount" in values area. Change the aggregation function to "Min".
Or use MINIFS():
=MINIFS(C2:C10150,A2:A10150,"May",B2:B10150,2020)