Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / March 2008

Tip: Looking for answers? Try searching our database.

Multiple field count function use

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Judy Rose - 03 Mar 2008 18:49 GMT
I have a criteria where I want to count a line of data if one date field is
filled in and another date field is empty (I want it to count the phone
interview completed but not entered into the system).  How do I establish
this?  I have the one set up to count those entered through a countif
function but I don't want to double count those that have been contacted and
entered by using the same formula to count the ones contacted.  I read the
previous threads but they do not address dates in particular as the criteria
used to determine whether or not to count the line of data.

Thank you for your assistance in advance.
Signature

Judy Rose Cohen

T. Valko - 03 Mar 2008 21:47 GMT
This is very confusing:

>I have the one set up to count those entered through a countif
>function but I don't want to double count those that have been
>contacted and entered by using the same formula to count
>the ones contacted.

Can you post a small example and the expected result?

Signature

Biff
Microsoft Excel MVP

>I have a criteria where I want to count a line of data if one date field is
> filled in and another date field is empty (I want it to count the phone
[quoted text clipped - 8 lines]
>
> Thank you for your assistance in advance.
Roger Govier - 04 Mar 2008 00:06 GMT
Hi Judy Rose

With first date in column A and second date in column B
=COUNTA(A:A)-COUNTIF(B:B,"<>")

The first part counts all the rows in column A with Dates, and the second
part deducts all those cells in column B which are not empty
Change ranges to suit.
Signature

Regards
Roger Govier

> I have a criteria where I want to count a line of data if one date field
> is
[quoted text clipped - 9 lines]
>
> Thank you for your assistance in advance.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.