HI there,
I should have changed my example to read that the A9 reference is actually
A3 and not part of my indicators.

thanks for that call-out - I can see where that would be a problem if it
were actually included in my indcators. SOrry for the confusion on that typo.

"JE McGimpsey" wrote:

Perhaps because you're dividing the SUMIF() result by A9, which
ostensibly is part of your indicators, rather than the number of stores?

In article ,
Jane wrote:

I have used this formula before with success to get an average - (col A
includes my indicators; col R includes my sales data; col F includes my # of
stores by which the sales data is divided):
=SUMIF($A$5:$A$500,"R:01",$R$5:$R$500)/$F$107

but I changed it to this for a different spreadsheet:
=SUMIF($A$5:$A$500,"BLENDED",$X$5:$X$500)/A9

Why would it work in the 1st instance but not in the 2nd?

thanks in advance! jane