Hi Rick, this ruturns all stores when Store = "All" and when Store = "Atlanta
Store" (of course I don't want all stores when Store = a specific store).
I love how simple it is though, any small tweek to get it to work?

"Rick Rothstein (MVP - VB)" wrote:

What about if you use ....*OR(StoreArray=Store,Store="All")*......

Rick

"Aaron" wrote in message
...
On of my criteria is ....*(StoreArray=Store)*......
But somtimes the range Store = "All" which is not a value in StoreArray.

So I tried .....*(If(store="all",1,StoreArray=Store))*.....

The 1 has the desired effect of skipping this criteria. But my false
statement is not having the desired effect. Any idea how I can do this?
(I'm
trying not to do a big if statement in the begining with one sumproduct
scenerio if true and anther if false)