Have you looked at powerbi integration?  This may be something you can accomplish there. We pull smart group data however I don't have a count of how many groups. 

Thanks for your reply. I've never tried PowerBI. I'm not sure if I got my point across or I'm misreading your response. The picture below shows the count and I'm wondering if that number can be automatically extracted to be used in Excel. But if you think PowerBI may be a good solution, I will give it a shot.

I'm not sure if you can pull that in into Excel without doing something like powerbi or an API call.  We do use smart groups to report on items within our PowerBI dashboard by referencing Computer device group -> 'computer_id'  and then selecting which group. You can then choose how to display this either with graphs, gauges, cards, etc....