PC Review


Reply
Thread Tools Rate Thread

CountIF - for cells that have data

 
 
=?Utf-8?B?Sm9leTA0MQ==?=
Guest
Posts: n/a
 
      16th Nov 2006
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?


--
Very Thankful
 
Reply With Quote
 
 
 
 
=?Utf-8?B?Um9uIENvZGVycmU=?=
Guest
Posts: n/a
 
      16th Nov 2006
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


"Joey041" wrote:

> 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?
>
>
> --
> Very Thankful

 
Reply With Quote
 
Biff
Guest
Posts: n/a
 
      16th Nov 2006
See reply to your other post in .MISC.

Biff

"Joey041" <(E-Mail Removed)> wrote in message
news:23F550AC-DB2A-40C2-9B37-(E-Mail Removed)...
>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?
>
>
> --
> Very Thankful



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
COUNTIF on NonContiguous Cells? RoadKill Microsoft Excel Worksheet Functions 5 5th May 2009 09:34 PM
COUNTIF, only counting once if both cells contain the data Navy Luke Microsoft Excel Worksheet Functions 4 2nd Dec 2008 10:26 PM
COUNTIF With Non-Continuous Cells =?Utf-8?B?TURX?= Microsoft Excel Worksheet Functions 3 16th Sep 2005 04:44 PM
countif criteria from two cells are met Carl Microsoft Excel Worksheet Functions 1 21st Jan 2004 08:50 PM
Countif if some cells contains ... Pedro Microsoft Excel Worksheet Functions 3 4th Sep 2003 12:45 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:59 AM.