Sverweis: Summe bilden - so lassen Sie Excel für Sie rechnen

Svweise as well as Wverweise are very helpful tools to make your work with Excel faster and more efficient. By knowing how to formulate the Sverweis so that you can automatically make a sum, you make sure that you don't have to do the math yourself.

So let Excel form a sum

It is important to formulate this Sverweis precisely and correctly. This is because with comprehensive data sets, you have a hard time tracking how Excel works correctly.

1. You can make it easy by using the sum formulaIf. To do this, use Sreference:=SUMWENN(x;x;x). You replace the x in the formula by specifying the desired places. However, this formula is only useful if you do not want to make complex calculations.
2. If you want to apply more than one criterion, you must choose the following Sverweis:=SUMPRODUKT((x:x=Y)*(y:y=Y)*Z1:Z2). The letters stand for the different parameters you can insert. This allows you to make more complex calculations within the data set.
3. Caution: Before you make extensive calculations with the formulated Sverweis, you should make one or two test runs. Because a consequential error can otherwise arise very quickly.

Is there an alternative?

You can see that it is easy to formulate an Sreference, but it also has a high potential for error. Alternatively, you can try using a pivot table, as this provides much better traceability. Especially for important data sets and if you don't have a wealth of experience regarding sreferences, you should give preference to the pivot table.