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

question by: Dan Zunko
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/bJluhcsE_r4;context-place=forum/docs

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:

	A	B	C	D	E	F	G
101	1	3	5	7	9		56
102	1	2	3	5	6		27
103	2	3	4				49
104	2	4					23
105	3	6	2	1	8		84
106	9	6	3	7			57
107	2	7	4	9	5		63

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