How do you add values in a column when determining the lowest amount within multiple groups

		Microsoft Office Forums > Microsoft Excel > Excel
How do you add values in a column when determining the lowest amount within multiple groups

09-06-2018, 07:38 PM

NoSparks

Windows 7 64bit How do you add values in a column when determining the lowest amount within multiple groups

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

See https://exceljet.net/formula/max-if-criteria-match

Try this array formula in E2 to get the discount

Code:

=IF($C2<MAX(IF($A$2:$A$20=$A2,$C$2:$C$20)),IF($B2="TC",0.5,0.25)*$C2,0)

confirmed with Shift+Ctrl+Enter not just Enter
and drag down

Attached Files

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
append multiple time values to date in one column	sarahafeez	Excel	1	09-25-2017 11:01 PM
2-Column layout breakes with images/groups	ben-in-m	Word	0	06-02-2017 01:26 PM
Multiple found values from five sheets, multiple returned values in sheet six?	irisha	Excel Programming	26	09-30-2016 01:20 AM
What formula can I use to find the lowest cell in a column that has a value in it?	EddyWD	Excel	3	04-20-2016 09:29 PM
Insert values from multiple rows based on value in one column	pachmarhi	Excel	3	07-18-2014 09:57 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:30 PM.