Excel quanity formula

Microsoft Microsoft office excel 2007 ac...
March 21, 2010 at 10:51:51
Specs: Windows XP
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 .


See More: Excel quanity formula

Report •


#1
March 21, 2010 at 11:12:34
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

http://www.skeptic.com/


Report •

#2
March 21, 2010 at 12:43:33
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


Report •
Related Solutions


Ask Question