Which one are you using, there is no built-in formula, so you must have
mis-transcribed it from some website.

--
HTH

Bob

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

"Danielah21" wrote in message
...
how can i enter SUMbycolor formula. It gives me error message REF!