Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

counting certain numbers

Status
Not open for further replies.
bobinot

bobinot

Technical User
Joined
Nov 19, 2005
Messages
2
Location
US
I want a formula that will only count certain numbers in a spreadsheet like count the number 1 only & I will be using this formula across numerous columns & rows.
 
Sort by date Sort by votes
I just looked in help, there is a countif @function that looks like it might do what you want.

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

unixcat56
  • Locked
  • Question Question
Counting occurences of data
Replies
4
Views
233
unixcat56
unixcat56
m0TiVe
  • Locked
  • Question Question
Conditional Counting (sumproduct)
Replies
1
Views
132
TonyGroves
TonyGroves
FrankLU
  • Locked
  • Question Question
Automatic Chapter Numbers
Replies
0
Views
92
FrankLU
FrankLU
lilbpaw
  • Locked
  • Question Question
QuickFill Exhibit Numbers and/or letters
Replies
2
Views
139
khobson
khobson
typing4dollars
  • Locked
  • Question Question
WP10 v. ordinal numbers
Replies
1
Views
125
KathleenF
KathleenF

Part and Inventory Search

Sponsor

Back
Top