On Fri, 17 Aug 2007 10:34:01 -0700, 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

PRobably because your data is different.

For example, in the second sheet, you are dividing by A9. Is that what you
really want to do? Is col A still your indicators on this different sheet?
--ron