Friday, October 7, 2011

yogi_Sum Rows of Columns With Minimum Value In A Specified Column

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
a user said:
How do I sum certain cells of a row that has the min value in a column?
I first need to find the cell containing the min value in a column and then I need to take the cell's row and sum certain cells in that row. Basically, SUM(C#,D#,F#,G#) where # is the row number that has the min value in column H - any ideas?
-------------------------------------