How can I count by date?

jhorvath

I attached a screenshot of my sheet. I want to count the number of Block ID instance per date. Any tips?

The end result would be a count of Block IDs in each cell that has a "Hierarchy Translation" == Date

Jeff Reisman

On your Date row (top hierarchy level):

COUNTIF(DESCENDANTS([Hierarchy Translation]@row), "Block ID")

This will count any rows which are descendants (not just child rows, but also children of child rows) of the Date row, where the Hierarchy Translation cell contains "Block ID".

Jeff Reisman

On your Date row (top hierarchy level):

COUNTIF(DESCENDANTS([Hierarchy Translation]@row), "Block ID")

This will count any rows which are descendants (not just child rows, but also children of child rows) of the Date row, where the Hierarchy Translation cell contains "Block ID".