Excel

  flobby 23:08 28 Sep 03
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 03

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 03

Definitely not!

  MAJ 23:12 28 Sep 03

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

  powerless 23:14 28 Sep 03

He has a name!

  flobby 23:24 28 Sep 03

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

  VoG II 23:25 28 Sep 03

Who?

  VoG II 23:25 28 Sep 03

Of course it works! ;o)

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

New Google phones UK release date | Pixel XL price, new features, specifications: Pixel X and…

1995-2015: How technology has changed the world in 20 years

This is the future of TV, VR and holograms

iPhone 7 review: Enhanced cameras, a refreshed design and water resistance make the iPhone 7 an…