software

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,
quot;1/15/2004quot;) all in one cell?

Thank you in advance for the assistance!

You can use a string. like this:

=quot;Blank= quot;amp;COUNTBLANK(g2:g1190)amp;quot;, Date o Second Option=
quot;amp;COUNTIF(g2:g1190,quot;1/15/2004quot;)

please click Yes in quot;Was this post helpful to you?quot; if this helped you.

Thanks.
--
Lorenzo DÃ*az
Cad Technicianquot;MJMPquot; wrote:

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

=COUNTBLANK(G2:G190)amp;quot; / quot;amp;COUNTIF(G2:G190,quot;1/15/2004quot;)

Vaya con Dios,
Chuck, CABGx3
quot;MJMPquot; wrote:

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