Yes. In fact, they should all be 0. These columns represent retail price
at different locations. If there's a zero in the column, it signifies that
this product is not being carried at this particular store.

"JE McGimpsey" wrote:

Do you have any values 0 in your target columns? If not, AVERAGE() will
return #DIV/0

In article ,
Renee - California wrote:

This returned a Div/0 result. Any Ideas???