In some of my reports, I needed to count the duplicate value for 1 or more specific products.
When I use the formula ?
To count duplicate value for 1 or more specific groups.
How to use the formula ?
The formula in this topic is with "," so depending of the operating system of your PC, the formula should have ";" instead of ",".
How are the formulas ?
=COUNTIF()
=COUNTIFS()
In E2, for 1 value:
=COUNTIF(A:A,"group1")
It counts the duplicate value, in this case, “group1”.
In E3, for 2 values:
=COUNTIFS(A:A,"group1",B:B,"=server")
It counts only all servers for the group1.
In E4, for 3 values:
=COUNTIFS(A:A,"group1",B:B,"server",C:C,"unix")
It counts only all unix servers for the group1.
When you are managing a team, “how to be a good manager” is the “must”...
As manager, I am doing many reports, even when I was an ITIL consultant, I still needed to do many reports...
ITIL V3 is going to be obsolete...
Managing an IT service when I start a new company is not an easy task, particularly true, if the service...