View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim
 
Posts: n/a
Default countif, sumif, sumproduct - I dont know which to use

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/2005 1 95
2 96
1/3/2005 0 8
1 308
2 533
1/4/2005 0 7
1 211
2 383


Tally
K L M
N O
0 1 2 3
Sunday, January 02, 2005 95 96
Monday, January 03, 2005 8 308 533
Tuesday, January 04, 2005 7 211 383