S
spirosu
I'm trying to perform a countif function and I was hoping some of th
more excel inclined individuals on this forum could help with this.
What I'm trying to accomplish below is to reference the dates (lef
most column) and then count how many times the same date occurs. Fo
example, 6/7/2004 has two records. Then I want to take that number an
look at whether it was a confirm or statement (3rd column), then I wan
to multiply by the amount, but I will have one new column searching fo
just confirms and another new column just for statements. For example
on 6/7/2004 there was a total of 2 confirms and 2 statements pulled
and for 6/8/2004, there was 1 confirm pulled and 0 statements. Thi
data will go into a second worksheet that I want to be in the forma
below (after the separating line).
Am I asking too much? Hopefully someone hear will be able to solve.
Thanks in advance for all your help!
First worksheet
6/7/2004 Mary-Alice Greco Confirm 2 Fax
6/7/2004 Mary-Alice Greco Confirm 2 Fax
6/8/2004 Michele Drella Confirm 4 Fax
___________________________________________
Second Worksheet
Date Confirms Statements
6/7/2004 2 2
6/8/2004 1
more excel inclined individuals on this forum could help with this.
What I'm trying to accomplish below is to reference the dates (lef
most column) and then count how many times the same date occurs. Fo
example, 6/7/2004 has two records. Then I want to take that number an
look at whether it was a confirm or statement (3rd column), then I wan
to multiply by the amount, but I will have one new column searching fo
just confirms and another new column just for statements. For example
on 6/7/2004 there was a total of 2 confirms and 2 statements pulled
and for 6/8/2004, there was 1 confirm pulled and 0 statements. Thi
data will go into a second worksheet that I want to be in the forma
below (after the separating line).
Am I asking too much? Hopefully someone hear will be able to solve.
Thanks in advance for all your help!
First worksheet
6/7/2004 Mary-Alice Greco Confirm 2 Fax
6/7/2004 Mary-Alice Greco Confirm 2 Fax
6/8/2004 Michele Drella Confirm 4 Fax
___________________________________________
Second Worksheet
Date Confirms Statements
6/7/2004 2 2
6/8/2004 1