Forum Discussion
one formula for combination of character in number of column
can anyone solve this for me please? I know how to put a formula in one column. but how could i put a formula for number of column to know a a combination in these column. example 1st column has ...
Use COUNTIFS, like this:
=COUNTIFS(A:A,”A”,
B:B,”B”,
C:C,”C”,
D:D,”D”)
=COUNTIFS(A:A,”A”,
B:B,”B”,
C:C,”C”,
D:D,”D”)