Probably because the changes you made to the formula were incorrect.

What do you mean when you say it didn't work? Did you get an error? an
incorrect result? a crash? no result?


In article ,
"Judy" wrote:

thanks to you both. This works on the same worksheet, but not a different
worksheet I'm using for a summary... why would that be?