how do you add multiple countsif statements in excel?

Give this a try:

=IF(COUNTIF($A$2:$A$14736, $A2)<2,"",COUNTIF($A$2:$A$14736, $A2)-1 & "X")

enter image description here

In the above example we have an original value and two duplicates.
If there are no duplicates (only the original), then the formula leaves the cell blank.
(if you want to count the total number of items (original + duplicates), then just drop the -1 in the formula)

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top