so i've this formula which is working
{=SUM(IF((Region=G7)+(Region=G8),Sales))}
But this formula isn't working with SUMPRODUCT. Doesn't the IF function return an array of sales based on my OR function ? SUMPRODUCT is supposed to add an array ? The SUM function is also working with CRTL+SHIFT+ENTER which shows its an array calculation.
Thanks for your time.
{=SUM(IF((Region=G7)+(Region=G8),Sales))}
But this formula isn't working with SUMPRODUCT. Doesn't the IF function return an array of sales based on my OR function ? SUMPRODUCT is supposed to add an array ? The SUM function is also working with CRTL+SHIFT+ENTER which shows its an array calculation.
Thanks for your time.