No tsure what you are doing, but have you tried a pivot table?
"mary" wrote in message
...
First let me say thanks to Rob. This formula works great,
except i need to add all the entries AFTER THIS FORMULA
HAS COLLETED THESE ENTRIES. EXAMPLE: ENTRIES OF
all "john". When i attempt to sum all the entries i am
getting an error message. Basically, because i am adding
up formula cells. Is there a macro that call sum up all
the value of a formula cells.
Thanks again ROB AND ANYONE THAT CAN HELP.