Formula help please

BCowans 

I think SergeiBaklan 's code is version neutral.  I am the one who uses problems to explore what could be done that is specific to 365.  When I first embarked on this voyage of discovery, my solutions were pretty useless to the OP but now there is an increasing proportion of users who could use the solutions, even though they may fail to meet expectations.

I had another look at the problem you specified today and finished up with

= ArrayCountIfλ(tableBody, "Y", tableHeader, header, tableAttribute, color)

where

ArrayCountIfλ
= LAMBDA(tbleBody, value, tbleHdr, hdr, tbleColor, clr,
    LET(
      mask,   ISTEXT(hdr) * ISTEXT(clr),
      hdrArr, IF(mask, hdr),
      clrArr, IF(mask, clr),
      MAP(hdrArr, clrArr, LAMBDA(h, c, COUNTIFS(XLOOKUP(h, tbleHdr, tbleBody), "Y", tbleColor, c)))
    )
  )

One day and I might even get to use it myself!