Count
You can use a string. like this:
="Blank= "&COUNTBLANK(g2:g1190)&", Date o Second Option=
"&COUNTIF(g2:g1190,"1/15/2004")
please click Yes in "Was this post helpful to you?" if this helped you.
Thanks.
--
Lorenzo DÃ*az
Cad Technician
"MJMP" wrote:
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!
|