Eureka! I found a related posting and did this:
- replaced "BLENDED" w/ D3 where I placed the word BLENDED

=SUMIF($D$12:$D$45,$D$3,$F$12:$F$45)/D4

Thanks all for your ideas!

take good care

"Jane" wrote:

forgive my typo on that - I intended to say that my # of stores was in a cell
outside of my indicators - sorry for that confusion.

I've tried the suggestions frmo other s with no luck although I am filing
the suggestions for use in other instances if needed so I have learned a few
more things so happy with that :)

any other thoughts?

thanks, jane

"Ron Rosenfeld" wrote:

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