CountIF - for cells that have data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joey041 - 16 Nov 2006 01:41 GMT

I am trying to get a count on cells that have multiple data.
So, what I really want is to Not Count the empy cells in my totals.

Can you help?

Signature

Very Thankful

Reply to this Message

Ron Coderre - 16 Nov 2006 01:56 GMT

Have you tried the COUNT, COUNTA, or COUNTIF functions?
If they didn't return what you want, then can you share a sample of your
data AND the formulas you've tried. Also, mention what they returned and what
you expected, instead.

***********
Regards,
Ron

XL2002, WinXP

> I am trying to get a count on cells that have multiple data.
> So, what I really want is to Not Count the empy cells in my totals.
>
> Can you help?

Reply to this Message

Biff - 16 Nov 2006 03:39 GMT

See reply to your other post in .MISC.

Biff

>I am trying to get a count on cells that have multiple data.
> So, what I really want is to Not Count the empy cells in my totals.
>
> Can you help?

Reply to this Message