Adding values of cells based on other cells in the same column

[xryanx]

C4 needs to have the total sum of all Values from J16:J200 that have the value in B16:B200 that is equal to A4.

Example: Because A4 is RK and B16 is RK, C4 will equal $250.
IF I add a new row and B18 is RK and J18 is $250, then C4
will be $500.

Thank you for any help.

	A	B	C	D	E	F	G	H	I	J
3	SP	# of Fails	$$$	SP	# of Fails	$$$		Total Crackouts	2
4	RK	1		11				Total $$$	$470.00
5	DR	1		12
6	HS			13				Avg Lovgevity	213.5
7	BP			14
8	JY			15
9	6			16
10	7			17
11	8			18
12	9			19
13	10			20
14
15	Date	SP	Location	Date of Repair	Referral #	Name	Vehicle	Date of Replace	$$$
16	1/1/2018	RK	NEL	1/1/2017	6549876549	johnson johnson and	2018 ford expedition lkkk	12/30/2018	$250.00
17	2/2/2018	DR	LV	12/2/2017	321321	bobb			$220.00

<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 82px;"><col style="width: 82px;"><col style="width: 82px;"><col style="width: 82px;"><col style="width: 82px;"><col style="width: 82px;"><col style="width: 82px;"><col style="width: 166px;"><col style="width: 82px;"><col style="width: 64px;"></colgroup><tbody>
</tbody>

Spreadsheet Formulas

Cell Formula I3 =COUNT(A16:A202) B4 =COUNTIF(B16:B200, A4) E4 =COUNTIF(B16:B200, D4) I4 =SUM(J16:J202) B5 =COUNTIF(B16:B200, A5) E5 =COUNTIF(B16:B200, D5) B6 =COUNTIF(B16:B200, A6) E6 =COUNTIF(B16:B200, D6) I6 =SUM(K16:K202)/I3 B7 =COUNTIF(B16:B200, A7) E7 =COUNTIF(B16:B200, D7) B8 =COUNTIF(B16:B200, A8) E8 =COUNTIF(B16:B200, D8) B9 =COUNTIF(B16:B200, A9) E9 =COUNTIF(B16:B200, D9) B10 =COUNTIF(B16:B200, A10) E10 =COUNTIF(B16:B200, D10) B11 =COUNTIF(B16:B200, A11) E11 =COUNTIF(B16:B200, D11) B12 =COUNTIF(B16:B200, A12) E12 =COUNTIF(B16:B200, D12) B13 =COUNTIF(B16:B200, A13) E13 =COUNTIF(B16:B200, D13) <tbody> </tbody>

<tbody>
</tbody>

 

[asad]

Try in C4:

=sum(if($B$16:$B$20=A4,$J$16:$J$20,0))

entered as an array formula.

 

[xryanx]

Thank you, I tried that formula, but it gave me an error "Value". I tried =SUMIF(B16:B200, A4, J16:J200) and that worked. Thank you for your help.

 

[asad]

What ever works for you my friend.