Monday, April 9, 2018

yogi_Sum Entries In Column G Of Rows That House A Specified Entry In Cells A101:F107

Google Spreadsheet   Post  #2417

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Apr-09-2018

Add column if row contains a certain value

Hi All.

I'm fairly good with Excel and Sheets, but I have a problem that has me stumped.  Consider the following:

ABCDEFG
1011357956
1021235627
10323449
1042423
1053621884
106963757
1072749563
I would like to calculate the SUM of the last column (G)  IF a certain number appears in the same row.

For example, Lets say x=1.  I would like to find the sum of column G in any row which contains a value of 1,
In this example, row 101, row 102, and row 105 contain a value of "1", so I want the sum of G101, G102, and G105.

I thought about Match, Index, Vlookup, and Find, but I can't seem to get them working together to give my desired result.

Any ideas?

Thanks so very much!!!

Dan