Hello Forum,
I have attached a workbook.
Please refer to cell reference: I42 (which has a formula based on category, 'major' which gives a result of $630.00 (based on sum of range: I5:I37)
I am unsure how to incorporate a MIN formula to have the lowest (minimum) amount of cell I42 or I49.
Can I please have some assistance?
Thank you
Hi Aussibuilder,
In I42,
=MINIFS($I$5:$I$37,$H$5:$H$37,"Maj")
Is that what you want?
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Note that MINIFS is available only in the subscription version.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks