SUMPRODUCT with additional sums/ adds

[joshua1990]

Hey guys!Is there a way to separate the SUMPRODUCT function with multiple search criteria if the range is fixed?Range: A2: BC200Target: Sum of all "Exit", "Go", "HA", "Hazard" etc.It is about 16 values, which should be counted and added.Unfortunately, Countif is not possible because it is a closed file.Best regards
Hey guys!Is there a way to separate the SUMPRODUCT function with multiple search criteria if the range is fixed?Also range: A2: BC200Target: Sum of all "Exit", "Go", "HA", "Hazard" etc.It is about 16 values, which should be counted and added.Unfortunately, Countif is not possible because it is a closed file.Best regards

[werafa]

you can append multiple sumproduct formula, eg sumproduct(criteria 1) + sumproduct(criteria 2) etc.
alternatively, write a custom function