Excel HELP

**IEatGlue** · Posted: Sat Jul 29, 2006 6:23 am Post subject: Excel HELP

so i have a list of movies in the A collum

and i need a formila to count how mant movies i have

so i need it to cound EVERYTHING entered into collum a then subtract 1

i have no idea how to do this or maby like a1 to a500 if you can't to the whole a thing
_________________

**joker** · Posted: Sat Jul 29, 2006 6:51 am Post subject:

shit! i don't have excel on this PC! do you need it immediately? i can have a formula for you on monday if you want to wait, but i don't know off the top of my head.
_________________

**trofl** · Joined: 26 Apr 2006 Posts: 1297 Location: Ames, IA

I'm confused... can't you just scroll down and see how many entries there are in Column A since the left axis is numbered?

Otherwise just stick in a column that isn't A:
=COUNT(A1:A65536)-1
_________________

"Science. It works, bitches."
And what's the harm in ignoring it?

**IEatGlue** · Posted: Sat Jul 29, 2006 4:52 pm Post subject:

noooooooo

i started at like "5" O_o and "3" i think has the words "Name"

so i didn't start at 1

and i GUESS i could wate, >_<
_________________

**Genga** · Joined: 19 Apr 2006 Posts: 2474 Location: Glasgow, Scotland

well subtract another 4 to compensate for fields 1-4
_________________

ScoreHero's First Ever Mascot!

**IEatGlue** · Posted: Sat Jul 29, 2006 6:10 pm Post subject:

no

i don't have anything entered their

i just need it to count EVERY cell that has somthing in it whitch would be movie names in the "A" collum THEN subtract one, if if you can't subtract 1 then from A5 to A100
_________________

**emptyset** · Posted: Sat Jul 29, 2006 6:12 pm Post subject:

Maybe a simple command like:

=SUM(A1:A500)-1

would work, for example.

I'm not exactly sure what you're trying to do with your spreadsheet, but that's the only advice I can offer.
_________________

**Genga** · Joined: 19 Apr 2006 Posts: 2474 Location: Glasgow, Scotland

thats only if theres numbers in the field
_________________

ScoreHero's First Ever Mascot!

**IEatGlue** · Posted: Sat Jul 29, 2006 6:59 pm Post subject:

**Hellion42** · Posted: Sat Jul 29, 2006 7:25 pm Post subject:

I don't know much about Excel, but the wiki is usually a good place to start looking.
_________________

**IEatGlue** · Posted: Sat Jul 29, 2006 7:28 pm Post subject:

that was ajoke right?

i ment the spread sheep program... by microsoft?
_________________

**Hellion42** · Posted: Sat Jul 29, 2006 7:31 pm Post subject:

**trofl** · Joined: 26 Apr 2006 Posts: 1297 Location: Ames, IA

Try =COUNTA instead of =COUNT in my formula.
_________________

"Science. It works, bitches."
And what's the harm in ignoring it?

**IEatGlue** · Posted: Sat Jul 29, 2006 7:48 pm Post subject:

**IEatGlue** · Posted: Sat Jul 29, 2006 7:54 pm Post subject:

is that i was talking about, yay!
_________________