Double Dash In Sumproduct Formulas
Click on an empty cell (1), and type in =SUMPRODUCT(–(D4:D8=”South”);E4:E8) – SUMPRODUCT(–(D4:D8=”South”);F4:F8) (2).
Note: We’d subtract expenses from revenue for only South. How you use the SUMPRODUCT with double dash lies on what you would like the formula to obtain from the whole data.
Now you can use excel–