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

NoSparks · #1 09-07-2018, 08:26 AM

Quote:

the highest number should not calculate and populate

change the last 0 in the formula to ""

as you can see from the link included the MAX(IF portion of the formula is an array formula
when you enter a 'normal' formula into a cell you just hit Enter for Excel to accept it
with an array formula you have to hit Shift+Ctrl+Enter all at the same time for Excel to accept it as an array formula

and Excel will automatically add the { and } to the formula.

drag down... click and hold on that little square in the lower right corner of the cell and pull it down the column to copy the formula to those cells

Hope that helps.

wheddingsjr · #2 09-07-2018, 12:35 PM

Thanks NoSparks, that did the trick and it work out perfectly. I truley appreciate all of your help

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