Count cells equal to 1 value case sensitive

=SUMPRODUCT((--EXACT(value, CellRange)))


© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top