I Need help to create a formula

Question

I need help to create a formula that look up column A. If there are values in this column, then sum its co-respondent values in column B. For example:&nbsp; &nbsp;A &nbsp; &nbsp; &nbsp; &nbsp; B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 15&nbsp; &nbsp;20 &nbsp; &nbsp; &nbsp; 32&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 28&nbsp;&nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp;the formula needs to provide a result of 42 since there are values 20 and 5 in column A.

hansvogelaar · Answer

For example:
=SUMIFS(B1:B100, A1:A100, "&lt;&gt;")
Adjust the ranges if your data extend below row 100.
Note: if you use comma as decimal separator, use ; instead of , in the formula:
=SUMIFS(B1:B100; A1:A100; "&lt;&gt;")
An alternative:
=SUM(B1:B100*(A1:A100&lt;&gt;""))

jmchou · Answer

thank you for the solution. You have shown a remarkable way to use&nbsp; &nbsp; &nbsp; &nbsp;"&lt;&gt;".&nbsp;

Forum Discussion

I Need help to create a formula

I need help to create a formula that look up column A. If there are values in this column, then sum its co-respondent values in column B. For example:
A B
15
20 32

28

5 10
the formula needs to provide a result of 42 since there are values 20 and 5 in column A.

2 Replies

Resources

Forum Discussion

I Need help to create a formula

I need help to create a formula that look up column A. If there are values in this column, then sum its co-respondent values in column B. For example: A B 15 20 32

28

5 10 the formula needs to provide a result of 42 since there are values 20 and 5 in column A.

I need help to create a formula that look up column A. If there are values in this column, then sum its co-respondent values in column B. For example:
A B
15
20 32

5 10
the formula needs to provide a result of 42 since there are values 20 and 5 in column A.