Extracting data
 

Hi All

I have a table with 3 columns of dates and then a column with Set # that I
feel in the box #.
I need to see how many items processed for each set per day.

Example:
www.amir2000.nl/1.doc

The problem is that it counts the correct amount but not with the correct
dates.
The formula that I use is:

=SUMPRODUCT(--($I$3:$I$8<"")*(($C$3:$C$8=39601)+AND($E$3:$E$8=3 9601)+AND($G$3:$G$8=39601)))

Is anyone can help?

Many thanks in advance,

Amir

Extracting data
 

Maybe...

=SUMPRODUCT(--($I$3:$I$8<""),
--((($C$3:$C$8=39601)+($E$3:$E$8=39601)+($G$3:$G$8=3 9601))0))

But I'd use:

=SUMPRODUCT(--($I$3:$I$8<""),
--((($C$3:$C$8=date(2008,6,2))
+($E$3:$E$8=date(2008,6,2))
+($G$3:$G$8=date(2008,6,2)))0))

(or put the date in a different cell and use that cell in the formula.

amir2000 wrote:

Hi All

I have a table with 3 columns of dates and then a column with Set # that I
feel in the box #.
I need to see how many items processed for each set per day.

Example:
www.amir2000.nl/1.doc

The problem is that it counts the correct amount but not with the correct
dates.
The formula that I use is:

=SUMPRODUCT(--($I$3:$I$8<"")*(($C$3:$C$8=39601)+AND($E$3:$E$8=3 9601)+AND($G$3:$G$8=39601)))

Is anyone can help?

Many thanks in advance,

Amir

--

Dave Peterson

Extracting data
 

Hi again
Thanks but it's giving me the same result.
For examole in set 4 i processed 3 on the: 03/06, 05/06 and 06/06.
The formula shows:
02/06,03/06 and 04/06.
For some reason it shows only the first date column.
It counting ok but by the date.

Thanks,
Amir
--
www.amir2000.nl


"Dave Peterson" wrote:

Maybe...

=SUMPRODUCT(--($I$3:$I$8<""),
--((($C$3:$C$8=39601)+($E$3:$E$8=39601)+($G$3:$G$8=3 9601))0))

But I'd use:

=SUMPRODUCT(--($I$3:$I$8<""),
--((($C$3:$C$8=date(2008,6,2))
+($E$3:$E$8=date(2008,6,2))
+($G$3:$G$8=date(2008,6,2)))0))

(or put the date in a different cell and use that cell in the formula.

amir2000 wrote:

Hi All

I have a table with 3 columns of dates and then a column with Set # that I
feel in the box #.
I need to see how many items processed for each set per day.

Example:
www.amir2000.nl/1.doc

The problem is that it counts the correct amount but not with the correct
dates.
The formula that I use is:

=SUMPRODUCT(--($I$3:$I$8<"")*(($C$3:$C$8=39601)+AND($E$3:$E$8=3 9601)+AND($G$3:$G$8=39601)))

Is anyone can help?

Many thanks in advance,

Amir

--

Dave Peterson

Extracting data
 

Any suggestions???

Thaks,

Amir
--
www.amir2000.nl


"amir2000" wrote:

Hi again
Thanks but it's giving me the same result.
For examole in set 4 i processed 3 on the: 03/06, 05/06 and 06/06.
The formula shows:
02/06,03/06 and 04/06.
For some reason it shows only the first date column.
It counting ok but by the date.

Thanks,
Amir
--
www.amir2000.nl


"Dave Peterson" wrote:

Maybe...

=SUMPRODUCT(--($I$3:$I$8<""),
--((($C$3:$C$8=39601)+($E$3:$E$8=39601)+($G$3:$G$8=3 9601))0))

But I'd use:

=SUMPRODUCT(--($I$3:$I$8<""),
--((($C$3:$C$8=date(2008,6,2))
+($E$3:$E$8=date(2008,6,2))
+($G$3:$G$8=date(2008,6,2)))0))

(or put the date in a different cell and use that cell in the formula.

amir2000 wrote:

Hi All

I have a table with 3 columns of dates and then a column with Set # that I
feel in the box #.
I need to see how many items processed for each set per day.

Example:
www.amir2000.nl/1.doc

The problem is that it counts the correct amount but not with the correct
dates.
The formula that I use is:

=SUMPRODUCT(--($I$3:$I$8<"")*(($C$3:$C$8=39601)+AND($E$3:$E$8=3 9601)+AND($G$3:$G$8=39601)))

Is anyone can help?

Many thanks in advance,

Amir

--

Dave Peterson