I hope its possible, I went through all the trouble to find help to get this formula to find the totals of min and max within a table, but I forgot that I had to multiply each row which is represented by a person with details for each person, and a total for each person with the formula. So for anyone who can find a solution to take these two formulas and multiply each and still retain the "IF" formula equation since its still important that the formula be able to search my table, to find the min and max totals.
=IF($G8="Discount",MIN('Data Sheet'!$H$4:$H$10),IF($G8="Standard",MIN('Data Sheet'!$F$4:$F$10,""))) Then I autofill totals down column "O"
=IF($G8="Discount",MAX('Data Sheet'!$H$4:$H$10),IF($G8="Standard",MAX('Data Sheet'!$F$4:$F$10),"")) Then I autofill totals down column "P"
The table for is found in worksheet "Data Sheet". The totals column and the column for "Standard" and "Discount" can be found in worksheet "Summary"