Function CountCcolor(range_data As Range, criteria1 As Range, criteria2 As Range) As Longxcolor = criteria1.Interior.ColorIndexFor Each dataxIn range_data
If datax.Interior.ColorIndex = xcolor And data
这是一个不可行的解决方案: extractValue(datax, '/client/cl_name' ) as Clientfrom a_xml.xml_animals
Where extractValue(datax,'count(//animal/an_type[self:text()="bir