+ Reply to Thread
Results 1 to 6 of 6

Need some guidance

  1. #1
    Registered User
    Join Date
    01-29-2007
    Posts
    18

    Need guidance counting non null values

    I am trying to count NOT IS NULL values in one column based on what city they are in. The City is in another column. I have tried the following formulas and they are not getting the data I need. Could use some help here. Thank you in advance for any assistance

    Here are the formulas I have used so far.

    Please Login or Register  to view this content.
    I also tried this, it counted the none null values but I couldn't specify what city I wanted it to be counting.

    Please Login or Register  to view this content.
    Thanks again
    Last edited by nfison; 05-02-2007 at 10:04 AM.

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,440
    Do you mean all the cells that are not empty?

    =SUMPRODUCT((Cascade Detail!O10:O7009="Kansas City")*(Cascade Detail!AC10:AC7009<>""))
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Registered User
    Join Date
    01-29-2007
    Posts
    18
    Yes it is non-blank cells. Cells that have been completed will have a asset tag number in the field. The ones that are not complete are blank. Now the range in the first part of that code should be the range that would have the city in it correct? And then I am doing a times function for cells that are not blank.

    It didn't work for me. Is there a formatting issue I should do first?

  4. #4
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,440
    This worked for me on a test range

    The first part of the arguement is the city, which is multiplied by the occurences of non blank cells in the second range.

    Make sure the ranges are the same size

  5. #5
    Registered User
    Join Date
    01-29-2007
    Posts
    18
    Very weird. I copied the two columns of data that I am doing this on into a blank workbook and it worked perfectly. Yet it won't work in my workbook where all my data is. Everything is exactly the same. I don't get it.

  6. #6
    Registered User
    Join Date
    01-29-2007
    Posts
    18
    Okay, I figured out why it was doing that to me. Once I changed the name of the worksheet from Cascade Detail to just detail it worked perfectly for me.

    Can anyone tell me why on that?

+ 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