+ Reply to Thread
Results 1 to 3 of 3

logic math formula

  1. #1
    Registered User
    Join Date
    09-26-2006
    Posts
    3

    logic math formula

    OK bare with me i'm a noob.
    I am trying to track attendance for work, I have four columns for different types of call ins, all I want to do is put a date in the column under the type of call-in. The fifth column I want it to auto total the number of call-ins. I'm pretty sure this is a logic function, not a math function. How do I go about wanting to basically total a number of cells that has any kind of info in it. EX:

    A B C D E
    8/22/06 8/25/06 Empty 8/28/06 3

  2. #2
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by irishlad
    OK bare with me i'm a noob.
    I am trying to track attendance for work, I have four columns for different types of call ins, all I want to do is put a date in the column under the type of call-in. The fifth column I want it to auto total the number of call-ins. I'm pretty sure this is a logic function, not a math function. How do I go about wanting to basically total a number of cells that has any kind of info in it. EX:

    A B C D E
    8/22/06 8/25/06 Empty 8/28/06 3
    =4-COUNTBLANK(A1:D1)

    ---

  3. #3
    Registered User
    Join Date
    09-26-2006
    Posts
    3
    Thanx Bryan that worked great! lol took me a while to figure out the (4-countblank) finally dawned on me that the 4 was how many columns I wanted added.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1