Your absolutely correct Biff, it does work!
Except if there are empty cells in any column, which is the case. What
changes to your formula have to be made to make it disregard empty cells?

"Biff" wrote:

It still didn't work.

If you looked at the screencap you would have seen that it does in fact
work.

Would you like for me to look at your file? Is that possible? If it's a huge
file I don't need the whole thing, just the sheet with this particular data.
Just let me know how to contact you.

Biff

"Vegs" wrote in message
...
It still didn't work.

What if I forget about searching column B and just use the s/n between the
dates. Excluding the duplicates of course. I tried this formula but had
no
success.

=SUMPRODUCT(--($A$33:$A$2006=$C$5-CHOOSE(WEEKDAY($C$5),0,1,2,3,4,5,6)),--($A$33:$A$2006<$C$5-CHOOSE(WEEKDAY($C$5),0,1,2,3,4,5,6)+7),--N(FREQUENCY(C33:C2006,C33:C2006)0))




"Biff" wrote:

The "IF" function needs a "value if false".......

The IF function does not need a value_if_false argument.

This is the formula I'm trying but is not working.
=SUM(N(FREQUENCY(IF((A33:A2006=$C$5-CHOOSE(WEEKDAY($C$5),0,1,2,3,4,5,6))*(A33:A2006<$C $5-CHOOSE(WEEKDAY($C$5),0,1,2,3,4,5,6)+7)*(B33:B2006= "5055"),MATCH(C33:C2006,C33:C2006,0)),MATCH(C33:C2 006,C33:C2006,0))0)

(B33:B2006="5055")

Should be:

(B33:B2006="A5055")

Based on the snippet of data you posted (not knowing what date you have
entered in C5)......

See this screencap:

http://img119.imageshack.us/img119/2631/sample6vq.jpg

Biff

"Vegs" wrote in message
...
How would I change the equation below to count the S/N (excluding
duplicates)
in column "C". Using the P/N in column "B". Here is the spreadsheet
I'm
working with.
The formula I'm currently trying is listed after the spreadsheet.

=SUMPRODUCT(--($A$33:$A$2006=$C$5-CHOOSE(WEEKDAY($C$5),0,1,2,3,4,5,6)),--($A$33:$A$2006<$C$5-CHOOSE(WEEKDAY($C$5),0,1,2,3,4,5,6)+7),--($B$33:$B$2006="A5055")

Date P/N S/N
6/26/2006 A5055 1234
6/26/2006 A5055 4321
6/27/2006 A5055 1212
6/28/2006 A5055 1212
6/28/2006 A5055 2121

This is the formula I'm trying but is not working.
=SUM(N(FREQUENCY(IF((A33:A2006=$C$5-CHOOSE(WEEKDAY($C$5),0,1,2,3,4,5,6))*(A33:A2006<$C $5-CHOOSE(WEEKDAY($C$5),0,1,2,3,4,5,6)+7)*(B33:B2006= "5055"),MATCH(C33:C2006,C33:C2006,0)),MATCH(C33:C2 006,C33:C2006,0))0)


"Vegs" wrote:

Hi Biff,

I'm coming up with an "N/A".
The "IF" function needs a "value if false".......
Thanks for your help...

"Biff" wrote:

Hi!

Try this:

Entered as an array using the key combo of CTRL,SHIFT,ENTER:

=SUM(N(FREQUENCY(IF((A33:A2006=Date1)*(A33:A2006< Date1+7)*(B33:B2006="A5055"),MATCH(C33:C2006,C33:C 2006,0)),MATCH(C33:C2006,C33:C2006,0))0))

In order to shorten the formula just a little I used a named
formula:

Date1 refers to:

=$C$5-CHOOSE(WEEKDAY($C$5),0,1,2,3,4,5,6)

Biff

"Vegs" wrote in message
...
I need this formula to exclude duplicate S/N which are enterd in
C33:C2006
for the part "A5055"

=SUMPRODUCT(--($A$33:$A$2006=$C$5-CHOOSE(WEEKDAY($C$5),0,1,2,3,4,5,6)),--($A$33:$A$2006<$C$5-CHOOSE(WEEKDAY($C$5),0,1,2,3,4,5,6)+7),--($B$33:$B$2006="A5055")