Microsoft Microsoft office excel 2007 ac...

I WOULD LIKE TO CREATE A FORMULA THAT WOULD GIVE ME A TOTAL QUANITY COUNT. THE UNIQUE VALUE ENTERED IN EACH CELL MAY RANGE FROM 1 TO 100 .

Given the amount of information youâ€™ve supplied, the best I can offer is: =COUNT(A1:A100)

=COUNTIF(A1:A100,12) Will count all the number 12's

MIKE

DIGITS: Please refrain from posting in all caps.

It is commonly considered to be shouting when you use all caps and nobody likes to be shouted at.

Thank you.

DerbyDad03

Excel Forum Moderator

Ask Your Question

Weekly Poll

Do you think Microsoft's new Surface Go will be a hit?

Discuss in The Lounge

Poll History