Thread: Count
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MJMP
 
Posts: n/a
Default Count

I have a column (column G) that is used to track attendance dates. I
currently have another cell that has the equation =countblank(g2:g190) to
come up with the number of people who still needs to attend. Is there a way
to take the first equation and add it another equation =countif(g2:g190,
"1/15/2004") all in one cell?

Thank you in advance for the assistance!