HI Bob,
The "blended" was exported into excel so I:

1. went to the beginning and end of the work and backspaced/ deleted
acocrdingly and no spaces involved.

2. formatted as text as it formatted as 'general'

3. highlighted and did "text to columns" in the case it exported over as an
object.

No luck on any of it.

other thoughts I can try?

thank you, Jane
"Bob Phillips" wrote:

Is the data actually BLENDED, no leading/trailing spaces?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Jane" wrote in message
...
I receive a "0" result

sample data:

col A col X A9 - 4
HISPANIC $45,093
HISPANIC $23,237
BLENDED $23409
AFR AMRCN $68450
BLENDED $19840
OTHER $75483
OTHER $09345

The sales data is actually a result of vlookup so I did a copy\ paste
special value and change the format from currency to number

what else should I cansider?

"Elkar" wrote:

The formula does appear to be written correctly. How is it not working?
Are
you receiving and error? Do you get the wrong result?

Without knowing more about your data, the results you're getting, and the
results you're expecting, the only thing I can suggest is to make sure
that
your data in X5:X500 and A9 are all in fact numbers, and not text or
numbers
stored as text.

HTH,
Elkar



"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