Bob, Excellent, I can't thank you enough for this information!!!

Bob Phillips wrote:
Hi Debbie,

The curly brackets are used to contain an array of constant values, so the
COUNTIF works on the array, that is both 3.028 and 4.04, rather than a
single value

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

Bob - Thank you soooo much. This works fabulously! I just have one more
question if you have time to answer. What do the { } brackets indicate as
[quoted text clipped - 22 lines]
percentage of 3000 & 5000 that equal 3.028 or 4.04 thanks for any help you
can offer.

--
Message posted via http://www.officekb.com