Searching in rows, and only counting cells that have

Hi

I need to search in a row, and only count variables that have "yes" in cells that have a column heading containing the text "Device" (the names of the column headings themselves vary, but the ones I am interested in all contain the text "Device"). Is there a simple way of doing this? Thanks

A =COUNTIFS() should work for you.

With your Headings in Row 1 starting in column B
and your "yes" cells in Row 2, also starting in column B
try this:

=COUNTIFS(B1:F1,"*device*",B2:F2,"Yes")