Counting multiple conditions

**Sippy69** · 11-10-2008, 11:35 AM

Hey all,

I could use some help with this one.
My worksheet contains a database of systems that have been installed since 6/08. Each system has its own unique serial number, however, this serial number appears more than once.
I'm trying to count the number of systems that have been installed since 9/08/08 but I do not need Excel to count each s/n entry, I only want it to return a count per s/n once to get a total of all installations since this date.
I have attached the sheet in pk zip format.
Any thoughts?
Thanks in advance.

**Gearcutter** · 11-10-2008, 12:51 PM

Hi
assuming I have put the correct serial number in formula for the date try the following and drag down;
=IF(AND(C2>=39669,COUNTIF($B$2:B2,B2)=1),COUNTIF($B$2:B3002,B2),"")
hope this helps
regards Howard

**Sippy69** · 11-10-2008, 01:20 PM

Thanks Howard.

I tried this and it didn't work. Just curious on which column to place this function.

Also, should i change the 39669 to 9/8/08?

**Gearcutter** · 11-10-2008, 01:28 PM

Hi what answer did you get?
I tested it onyour worksheet in col A(Inserting an extra col)
Regards Howard

**Gearcutter** · 11-10-2008, 01:39 PM

Hi again,
I have attached the worksheet, let me know if this what you want

**Sippy69** · 11-10-2008, 01:41 PM

Let me try what you did and I'll get back shortly.
I can do the lookup formulas great but lack at the count forumulas. LOL.

**Sippy69** · 11-10-2008, 01:47 PM

Howard,
I see how you did this now.
Except here is the issue. I only need the s/n counted one time, and to only be counted if it matches the 9/8/08 or later install date,and not each time it appears.
Sorry for my confusion on my original post.
Would this count function still accomplish this?

**Gearcutter** · 11-10-2008, 03:01 PM

Hi,
In that case then amend the formula to:

=IF(AND(C2>=39669,COUNTIF($B$2:B2,B2)=1),COUNTIF($B$2:B2,B2),"")
and that will return 1 rather than counting each serial No
I put the formula in col A so I could compare how the formula worked against the date and the serial No you can enter the formula in a col at the end if you so wish.
Regards Howard