View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
telewats
 
Posts: n/a
Default Count if cells have multiple data


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!


--
telewats
------------------------------------------------------------------------
telewats's Profile: http://www.excelforum.com/member.php...o&userid=30270
View this thread: http://www.excelforum.com/showthread...hreadid=503520