Excel - Cell Title & Count Formula

  A p o l l o 18:43 20 Nov 2006

Can I have a cell in Excel (97) that contains text and also a formula?

The required result would look like:
Members 512
where the cell has both the word "Members" and also a formula such as =COUNTA(B2:B658,"")

Thanks in advance

A p o l l o

  VoG II 18:49 20 Nov 2006

="Members " & COUNTA(B2:B658)

  A p o l l o 22:02 20 Nov 2006

Easy when you know how!

(and now I know)

Many Thanks

A p o l l o

  daba 23:17 20 Nov 2006

Format the Cell as "Custom"

In the custom format put "Members "# this gives exactly same result.

One advantage of using custom formats is to be able to format the number part of the resulting cell contents. For instance,

"Members "###0 gives Members 0003

"Members "#,### gives Members 3,762 or Members 123,456,789 etc.

  Simsy 23:25 20 Nov 2006

than VoG™, I would have given the same solution. However daba makes a very good point...

Though I suspect it's not so in the instance, (from the use of the word "Members"), it's worth considering that the first solution offered means that the cells containing the formula cannot, (easily) be used in subsequent calculations.

With daba's method they can.

Neither is wrong, and both have appropriate uses, but it's something to think about! Well done all!



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 ?