Sum, Countifs, match Etc.

I really didn't know how to title this as it seems like I need to nest a few functions together ha. I am needing to count the number of times each unique number is found in a column, based on a location (found in another column) based on a month and year (found in two additional columns)

I tried figuring this out on my own and didn't get far. below is what I have and it does not work to say the least. I know it doesn't include everything I'm asking for but as I said, I was trying to start somewhere.

Please Login or Register  to view this content.

The following are the columns of interest:

A = Location

H = Column to count unique numbers

M = Month

N = year

If I can get this knocked out, it will lead me to another question...but we can cross that bridge when we get there ha.

any and all help would be greatly appreciated.

thanks

BR

after some more Googling, I was able to find this;

Please Login or Register  to view this content.

this has me half was there I think. it is telling me number of unique entries correctly.

Now I just need to count how many times each entry found. then narrow that down with countifs maybe to get it down to location, month, and year

Hopefully this will help. I tried the formulas you provided but couldn't get them to work. should the (--( be in there or is that a place holder for something I am supposed to enter?

Count Example.xlsx

thanks

Originally Posted by XOR LX

Hi.

Can you just clarify some of your expected results?

You have a value of 1 for Alice/Oct-13, though I cannot see any records which match these criteria.

You have a value of 3 for Dickinson/Apr-14, though I only see 2 (unique) records which match these criteria.

You have a blank for Alice/Oct-14, though I can see 1 unique record which matches these criteria.

Regards

Your right. I had oct - 13 and 14 confused. as for Dickinson I must have over counted

Nice, that works for me, thanks for the help.

on another note if you could help, now I need to find how many times a value is found in the well name column for a given month/year/district.

Nice, that works for me, thanks for the help.

on another note if you could help, now I need to find how many times a value is found in the well name column for a given month/year/district.

this should help.

Also, this being a sample or my actual data, the rows to be used go up to 10735 (including the header) when I tried changing the rows in the previous example to this number it returned a 0?

just thought I would throw that in there ha. thanks again for all your help

Count Example.xlsx

thanks
BD

well I thought I did, I must have made the changes and not save it or something. Nonetheless, we was able to get what I needed using a series of countifs and come cheater cells to achieve what I needed. Thanks again for all your help, it was much appreciated and will be used in the future.

thanks
Brice