Sum Multiple Rows with Vlookup?

[RoyceMelborne]

Hello,

I am trying to sum all of the CP rows using the indicator of 80 in column A. So for example I would like to return the value 124 for column D, 417 for column E and so forth.

I tried using a VLOOKUP but only the first value was returned. I also tried a SUMIF, but the Data Sheet is dynamic so the cell range changes. (The table below is just a snippet of the full Data Sheet)

Is there a formula I can use to accomplish this task?

Thanks all!

	A	B	C	D	E	F	G
1	72	37	Overdrafts	0	0	0	0
2	73	105	ST Loan Payable	0	0	0	0
3	75	105	Notes Payable	0	0	0	0
4	80	75	CP-Bank	20	21	25	26
5	80	75	CP-Lease	104	35	45	98
6	80	75	CP-Shareholder	0	361	723	0
7	81	75	CP-Subordinated Debt	0	0	0	0
8	85	25	A/P Trade	1198	2291	2338	2968
9	87	27	A/P - Other	0	0	0	0
10	91	70	Interest Payable	0	0	0	0

<tbody>
</tbody>

 

[Joe4]

Welcome to the Board!

Use SUMIF.

For column D, the formula would look like:

=SUMIF(A1:A10,80,D1:D10)

For all the other columns, use the same formula, changing the column D reference to your next column.

For more on SUMIF, see: https://www.techonthenet.com/excel/formulas/sumif.php

 

[RoyceMelborne]

That was easy, thank you!

 

[Joe4]

You are welcome!

There is also a COUNTIF function, which works somewhat similarly, which counts the cells meeting the criteria (instead of summing them).
And there is SUMIFS and COUNTIFS, if you multiple conditions you need to check.