Adding a Title to a COUNTIF formula
I am looking for guidance as I feel like I am missing something really simple. I would like to be able to have a title(label) included in my COUNTIF statement.
This is the total count formula I have for the parent row: ="May 2018" + " (" + COUNT(CHILDREN()) + ")"
This formula displays in the cell as May 2018 (3)
I want to be able to do a similar display in the parent row for truck loads that are going to one specific location.
This formula is not what I want because it counts all of the "specific location" entries on the entire sheet (not just the children within this parent row).
="US Loads (" + COUNTIF([Location]:[Location], "specific location") + ")"
This formula works, but does not display in the cell with a title. It only display that number.
=COUNTIF(CHILDREN(), "specific location")
I thought I was on the right track but this formula below is coming up as #UNPARSEABLE. What did I miss?
=“US Loads (“ + COUNTIF(CHILDREN(), "specific location") + ”)”