Excel Column "SET Filter to " in one column count in another
Stefi,
Open this screen wide...
I know you got me close with this array. Help me understand your formula.
What is A12 & B12?
Are you saying A12 Is "TIME" or "NAME"
IS B12 saying "Field" or "Age"
My coulumns are 3-73
A B C D E F G
H I
Time Field Age Home vs Visitor Ref
Side1 Side 2
9:00 AM Field #4 U-19 Keydets vs Vulcan Elton Joe
Suzy
9:00 AM Field #3 U10 United vs Blasters Mark Alex
Ricky
9:00 AM Field #2 U12 Arsenal vs Eagles Clayton Jake
James
9:00 AM Field #1 U-19 Crew vs Earthquakes Elton Forrest Eric
In a separate cell I want to be able to Sum the number of time that Elton
was a Ref for age group U-19. i am trying to sum up each age group for a
particular Ref so i can pay him. This is my actual spreadsheet. Thank you
Stefi.
"Stefi" wrote:
(End Product)
Name Age Center Side1 Side 1
John smith U12 "formula"-
John Smith U19 V
=SUMPRODUCT(--($A12=D$2:D$4),--($B12=$C$2:$C$4))
Replace "formula" by this formula and fillit to the right and down!
Regards,
Stefi
|