Excel

  flobby 23:08 28 Sep 2003
Locked

Hi,
can anybody help or is this the wrong forum to get advice on excel?
I can do a list of say, packages with numbers and weights that go with the numbers i.e.
No.4 = 100kg
No.7=120kg
No.12=110kg.

I can get the total weight at the end,= 330kg
But can I get the total number of packages that have been entered. = 3 and if so HOW?
Thank you in anticipation.
Cheers, Flobby

  VoG II 23:11 28 Sep 2003

Say your packages Are listed in A1 to A10

=COUNTA(A1:A10)

will return the total number of entries.

  VoG II 23:12 28 Sep 2003

Definitely not!

  MAJ 23:12 28 Sep 2003

He never fails, does he?? :-))

  powerless 23:14 28 Sep 2003

He has a name!

  flobby 23:24 28 Sep 2003

Thank you VOG, I have just tried it and it works.
Cheers, flobby

  VoG II 23:25 28 Sep 2003

Who?

  VoG II 23:25 28 Sep 2003

Of course it works! ;o)

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

Halloween Photoshop & Illustrator tutorials: 20 step-by-step guides to creating spook-tacular…

iPhone X news: Release date, price, new features & specs

Comment créer, modifier et réinitialiser un compte Apple ?