software

Hello,

Thanks for the help.

I need to count the data that was dumped into column A:C into L, M, N, and O.

If the date of column A matches the date in column K and if the number in
column B matches (say for this example) the number in column M I would like
to pull the number from column C to column O.

I showed in the tally how I would like the final product to look. Thanks
for the help.

Dump
A B C
1/2/2005195
296
1/3/200508
1308
2533
1/4/200507
1211
2383Tally
K L M
N O
0 1 2 3
Sunday, January 02, 20059596
Monday, January 03, 20058308533
Tuesday, January 04, 20057211383
=IF(AND(A2=K2,,B2=M2),C2,quot;quot;)

in O2

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Jimquot; gt; wrote in message
...
gt; Hello,
gt;
gt; Thanks for the help.
gt;
gt; I need to count the data that was dumped into column A:C into L, M, N, and
O.
gt;
gt; If the date of column A matches the date in column K and if the number in
gt; column B matches (say for this example) the number in column M I would
like
gt; to pull the number from column C to column O.
gt;
gt; I showed in the tally how I would like the final product to look. Thanks
gt; for the help.
gt;
gt; Dump
gt; A B C
gt; 1/2/2005 1 95
gt; 2 96
gt; 1/3/2005 0 8
gt; 1 308
gt; 2 533
gt; 1/4/2005 0 7
gt; 1 211
gt; 2 383
gt;
gt;
gt; Tally
gt; K L M
gt; N O
gt; 0 1 2 3
gt; Sunday, January 02, 2005 95 96
gt; Monday, January 03, 2005 8 308 533
gt; Tuesday, January 04, 2005 7 211 383
gt;
gt;

Try this in column O, adjusting ranges as necessary.

=sumproduct(($A$1:$A$100=K1)*($B$1:$B$100=M1)*($C$ 1:$C$100))--
Vito
------------------------------------------------------------------------
Vito's Profile: www.excelforum.com/member.php...oamp;userid=29182
View this thread: www.excelforum.com/showthread...hreadid=497867Since your dates do not repeat, doing this would be difficult.

If you fill in the missing dates you can do it by formula, but it would be
far easier to just create a pivot table with the dates as row headers, the
0,1,2 etc values as column headers, and the other numbers as your data values.

Use Data-gt; Pivot Table and Pivot Chart... and then follow the prompts

quot;Jimquot; wrote:

gt; Hello,
gt;
gt; Thanks for the help.
gt;
gt; I need to count the data that was dumped into column A:C into L, M, N, and O.
gt;
gt; If the date of column A matches the date in column K and if the number in
gt; column B matches (say for this example) the number in column M I would like
gt; to pull the number from column C to column O.
gt;
gt; I showed in the tally how I would like the final product to look. Thanks
gt; for the help.
gt;
gt; Dump
gt; A B C
gt; 1/2/2005195
gt; 296
gt; 1/3/200508
gt; 1308
gt; 2533
gt; 1/4/200507
gt; 1211
gt; 2383
gt;
gt;
gt; Tally
gt; K L M
gt; N O
gt; 0 1 2 3
gt; Sunday, January 02, 20059596
gt; Monday, January 03, 20058308533
gt; Tuesday, January 04, 20057211383
gt;
gt;