SUBTOTAL of SUMIFS for filtered rows

[PatRichard]

Struggling to get this to work. I have a SUMIFS that works fine:

=SUMIFS(SiteInfo[Number of buildings],SiteInfo[Country], "=United States of America (USA)")

But I want to exclude hidden rows, and from some research, SUBTOTAL seems to be the answer. But I can't get it to work with my SUMIFS. I thought maybe

=subtotal(109,SUMIFS(SiteInfo[Number of buildings],SiteInfo[Country], "=United States of America (USA)"))

would work, but Excel doesn't like that. Thoughts?

 

[Fluff]

How about

=sum(filter(SiteInfo[Number of buildings],(SiteInfo[Country]="United States of America (USA)")*(MAP(SiteInfo[Country],LAMBDA(m,SUBTOTAL(103,m))))))