Posted to microsoft.public.excel.worksheet.functions

Jon Ratzel[_2_] Jon Ratzel[_2_] is offline

external usenet poster

Posts: 16

Minimum Ifs Function

I need a formula that would work as a minimum ifs function similar to the
sumifs formula. Given the data set below I need the minimum list price for
the group in cell A1 but only only if the Use = Y and Finish = Red. Can
anyone help?

Group Use Finish List Price Min List Price
A X Red $10
B Y Blue $12
A Y Red $15 $15
C X Yellow $10
A Y Red $19 $15
B Y Red $9

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
minimum function but want to exclude zero	kinsey	Excel Discussion (Misc queries)	3	November 18th 10 02:46 PM
using min function without calculating 0 as minimum	chusu	New Users to Excel	2	October 4th 07 05:32 AM
How do I set a minimum value to be returned from IF function	KW	Excel Discussion (Misc queries)	1	June 27th 07 04:14 PM
Minimum function	bikemrh	Excel Discussion (Misc queries)	5	March 9th 07 08:25 PM
minimum function	cutyfurby	Excel Worksheet Functions	3	March 11th 06 06:47 PM

All times are GMT +1. The time now is 03:40 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us