PIVOTBY GROUPBY not getting text count

[Prosperina]

I'm trying to get account count totals by platform using pivotby and groupby (image attached).
The formula gets me the counts on the other columns that contain dates but returns 0 on the count of account names when using the count function.
I have tried using groupby COUNTA but on the dates, it is counting even the blanks.

 

[RoryA]

Instead of just COUNT, use HSTACK(COUNTA,COUNT,COUNT)

 

[RoryA]

A reminder:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

PIVOTBY not getting text count

I'm trying to get account count totals by platform using pivotby (image attached). The formula gets me the counts on the other columns that contain dates but returns 0 on the count of account names. 880033

www.excelforum.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Prosperina]

A reminder:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

PIVOTBY not getting text count

I'm trying to get account count totals by platform using pivotby (image attached). The formula gets me the counts on the other columns that contain dates but returns 0 on the count of account names. 880033

www.excelforum.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Sorry about that. I wasn't aware of that rule
Thank you for that solution. It worked.