Running Total for Unique Variables and a Condition

[Brow5213]

Hello!

I am trying to calculate a running total of specific groups, but I do not want a group to be counted if it does not have a posted date.

Currently, I am using the following CountIF formula: (=COUNTIF($H$6:H7,H7)). This formula is effective in helping me find the running total of unique groups, but it counts a group no matter if it has a posting date or not. I am hoping to have a running count that excludes those groups.

Please see the image for reference.

Thank you so much!

 

[Brow5213]

You need to remove the space between the < & > signs.

Thank you so much. Life saver!

 

[Fluff]

Glad we could help & thanks for the feedback.