Having troubles with conditional formatting

[Guest]

FOM DEC JAN
Rich G james-8
Mark Hamm Korry-11
Mark Hamm Chris-21 Dave-2, Matt-22,Chris 23
Mark Hamm Korry-26
Rich G Steve-20
Mark Hamm Matt-11 Matt-22
Mark Hamm Korry-3
Matt K
Mark Hamm Chris-25
Mark Hamm Korry-11
Rich G James-8
Mark Hamm
Mark Hamm
Rich G
Mark Hamm Chris O - 22
Mark Hamm
Matt K John K-16
Mark Hamm matt-7
Mark Hamm Korry-16
Mark Hamm Matt-11
Mark Hamm


Ok so here is what im trying to do, for example there are 4 rows that have
Rich G as FOM in those 4 rows there was 3 monthly checks done in DEC so at
the bottom of that column it would show 3, and for Jan it would show 0, I am
having trouble trying to write a formula that filters the month columns by a
FOM that counts how many rows have non blank cells if that row matches a
certain FOM.

 

[Guest]

Try this in B26 (DEC column, below last Mark Hamm entry)
=SUMPRODUCT(--($A$2:$A$25="Rich G"),--(B$2:B$25<>""))
You can fill that formula to the right to check JAN column (and others) --
as written it will always use names in column A and the B column will
automatically change as you fill to the right. Row numbers stay same
regardless.

You could use another cell's contents to replace the literal "Rich G" in the
formula and then what ever was in that cell is what would be tested as (to
still check for Rich G)
=SUMPRODUCT(--($A$2:$A$25=$A$2),--(B$2:B$25<>""))
or
=SUMPRODUCT(--($A$2:$A$25=$A$3),--(B$2:B$25<>""))
to count Mark Hamm entries.