Summary

Kristie Diersen

I am trying to find a way to do a monthly summary of the number items each month in Published, and Expired Alert Status.

Does anyone know what would be the best way to complete this?

Thanks!

Paul Newcome

Try something like this...

To get Published:

=COUNTIFS(CHILDREN(), @cell = "Published")

To get Expired:

=COUNTIFS(CHILDREN(), @cell = "Published")

To have them both displayed in an easy to read format within the same cell (enable text wrapping)...

="Published: " + COUNTIFS(CHILDREN(), @cell = "Published") + CHAR(10) + "Expired: " + COUNTIFS(CHILDREN(), @cell = "Published")

This will display it as

Published: #

Expired: #

within the same cell once you enable text wrap.

Paul Newcome

Try something like this...

To get Published:

=COUNTIFS(CHILDREN(), @cell = "Published")

To get Expired:

=COUNTIFS(CHILDREN(), @cell = "Published")

To have them both displayed in an easy to read format within the same cell (enable text wrapping)...

="Published: " + COUNTIFS(CHILDREN(), @cell = "Published") + CHAR(10) + "Expired: " + COUNTIFS(CHILDREN(), @cell = "Published")

This will display it as

Published: #

Expired: #

within the same cell once you enable text wrap.