The insurance premium is paid in every 3 months gap. Specify a number in every Nth cell. Suppose we are preparing a list of expenses of every month as below data: 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:
0 kommentar(er)
