joshua1990
02-08-2018, 03:04 PM
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
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