So, this formula is working by calculating the remainder using the MOD function. In case of odd numbers, (MOD($A$25:$A$31,2)=1)would return an array of TRUE, then SUMPRODUCT function adds only those numbers that are returning TRUE. In case of even numbers,(MOD($A$13:$A$20,2)=0) would return an array of TRUE, then SUMPRODUCT function adds only those numbers that are returning TRUE.ĪDD only the odd numbers in the given dataset:įor adding the odd values in the above-given dataset, we use the below formula: ADD only the even numbers in the given dataset:įor adding the even values in the above-given dataset, we use the below formula: