Countif with mult. criteria w/o duplicates

Microsoft Office excel 2007 - upgrade
February 11, 2011 at 13:19:06
Specs: Windows XP
I have three columns of data in a large file that I would like to summarize. I need to first count all rows that show area 1501 with a date of 2/1/11. I then would like to count how many serial numbers within that range. For output, I need the total count of unique serial numbers for a specific date and specific area.

Serial Number Date Area
1111 2/1/11 1501
1111 2/1/11 1501
1112 2/1/11 1501
1111 2/1/11 1502
1112 2/1/11 1502


See More: Countif with mult. criteria w/o duplicates

Report •


#1
February 11, 2011 at 16:21:58
What version of Excel are you using?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
February 14, 2011 at 05:53:19
Excel 2007

Report •

Related Solutions


Ask Question