Warning

 

Close
Confirm Action

Are you sure you wish to do this?

Cancel Confirm
AR15.COM
11/20/2005 2:23:24 PM EDT
I hate M$ crap, and yet it's all I have now

I have a spread sheet of all my firearms (that went down in that certain boating accident)

I want to count the number of pistols/rifles and shotguns in a certain column and have the result show up in it's own box.

I'm having a terrible time with this, I can do other things, but this is the first time I'm using words instead of numbers and I cant figure out which function to use or its syntax.   oddly enough, the cells I want to use are labled either "pistol", "rifle" or "shotgun".

someone's gotta know!

Please!?!?!
11/20/2005 2:29:55 PM EDT
[#1]
Assuming the column with the words that you want to add up is A1 through A9:

Put this in the cell to hold the number of "pistol" entries.

=COUNTIF(A1:A9,"pistol")

Do the same for rifle and shotgun.
11/20/2005 2:37:45 PM EDT
[#2]
If you hate M$ crap, then delete it from your computer and go here:
www.openoffice.org/

I got rid of MS office a long time ago.  OO has worked just fine.


11/20/2005 2:39:08 PM EDT
[#3]

Quoted:
Assuming the column with the words that you want to add up is A1 through A9:

Put this in the cell to hold the number of "pistol" entries.

=COUNTIF(A1:A9,"pistol")

Do the same for rifle and shotgun.



AHHHHAAAAA

Thanks, that did it
11/20/2005 3:11:30 PM EDT
[#4]
You can also do =COUNTIF(A1:A20,"*")  
this will count all cells that have text in them.
so if you want to know total, you can just do that.

Brian