On Fri, 20 Jan 2006 15:30:16 -0600, telewats
wrote:


Hello,

Is there a way to count cells that contain multiple data? For example,
I want to count the cells that contain "5 days:001", "5 days:002",
"5 days:003", etc. The cells contain more data than I've listed,
however this is the data I need to pull. I've tried the COUNTIF
function, and it seems to be working if I only include one or two
criteria, but I have six criteria I need to count.

Thanks!

=COUNTIF(rng,CRITERIA_1) + COUNTIF(rng,CRITERIA_2) + COUNTIF(...



--ron