So you want to group how many A's were in column F on each day, correct?

Easiest to make a little table with your list of dates. Your table would be
in, say, J2:K20 with dates down column J and your count formula below in K

Then do =sumproduct(--($A$2:$A$1000=J2),--($G$2:$G$1000="A"))


"Donna" wrote:

Hi,
IS THERE A WAY TO FIND ALL CORRESPONDING A'S FOR COLUMN "F" THAT HAVE
THE SAME DATE IN COLUMN A. WHAT I WOULD LIKE FOR IT TO DO IS IN ANOTHER
COLUMN TO NUMBER THE ADJUSTMENTS (COL G).
Col A Col B Col C Col D Col E Col F COL G
1/8/2008 2396112 50 NEW C
1/17/2008 25391 -50 R
1/28/2008 2406382 50 REN C
2/7/2008 25572 -50 A 1
7/22/2009 2716889 14,268.00 REN C
7/22/2009 -10,701.00 F
7/29/2009 1387 -3,567.00 R
7/22/2009 2716889F 10,701.00 REN F
8/12/2009 ach081209 -10,701.00 C
4/28/2008 26513 -1,136.00 R
4/21/2008 2453844 19 END C
4/28/2008 26596 -19 R
5/30/2008 2476656 1,155.00 INS C
6/24/2008 -1,155.00 V
6/24/2008 2490192 531 END C
8/1/2008 26784 -12 R
8/5/2008 -519 A 2
6/24/2008 2490197 1,297.00 INS C
6/26/2008 25972 -1,155.00 R
7/2/2008 -1,297.00 V
7/8/2008 1,155.00 A 3
7/2/2008 2495031 1,155.00 INS C
10/9/2008 30148 -1,155.00 R
7/3/2008 2496532 1,155.00 INS C
7/8/2008 -1,155.00 A 3
7/01/08 1234566 50.00 C
2/07/08 12345 -50.00 A
1
7/7/08 -519 C
8/05/08 123456 519.00 A
2