Summary
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!
Kristie Diersen 😀
Best Answer
-
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.
Answers
-
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.
Help Article Resources
Categories
Check out the Formula Handbook template!