Hi everyone,
I have a list of products divided by type. Each product has a different total area.
train2.png
I am looking for a formula that finds the maximum total area of a product type.
So let's assume in cell B27 I have a dropdown menu of Capsules and Tablets, a formula in B29 should show 10.64 if Tablets selected in B27 since there are 3 tablet products and the max total area is 10.64. Similarly, the formula should find max total area of the capsule products.
Thank you for your help.
Last edited by mq1973; 10-13-2023 at 12:42 AM.
in B29 put
=maxifs(c25:n25,c17:n17,b27)
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Thanks so much etaf. I appreciate it.
you are welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks