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 3...
For example:
=SUMIFS(B1:B100, A1:A100, "<>")
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; "<>")
An alternative:
=SUM(B1:B100*(A1:A100<>""))
thank you for the solution. You have shown a remarkable way to use "<>".
