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!

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!

=COUNTBLANK(G2:G190)&" / "&COUNTIF(G2:G190,"1/15/2004")

Vaya con Dios,
Chuck, CABGx3



"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!