Need some guidance

**nfison** · 05-02-2007, 09:52 AM

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

**sweep** · 05-02-2007, 10:09 AM

Do you mean all the cells that are not empty?

=SUMPRODUCT((Cascade Detail!O10:O7009="Kansas City")*(Cascade Detail!AC10:AC7009<>""))

**nfison** · 05-02-2007, 10:13 AM

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?

**sweep** · 05-02-2007, 10:21 AM

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

**nfison** · 05-02-2007, 10:29 AM

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.

**nfison** · 05-02-2007, 10:31 AM

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?

Need some guidance

LinkBack

Thread Tools

Rate This Thread

Display

Need guidance counting non null values

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions