search for an identifier in a group of 17 items. if found count it once

[joannelittell]

I have a growing database that is made up of 17 items per group. if any of the items start with an identifier (starts with an "x"), it needs be be counted once.

see my example

Thanks for any help.
Joanne

[zbor]

Here, try this:

Please Login or Register  to view this content.

[bolulusam]

if you have tons of rows of data use pivot table as i attached,

[jewelsharma]

try this:

Please Login or Register  to view this content.

[joannelittell]

this counts each of them within a group. it should only count it once.

[bolulusam]

used max at values part