Array using 2 columns
On 26 Maj, 19:31, Airchief wrote:
Help
Open this screen wide...
*I know I can do this with aray. Can anyone help me??
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
Hi
This should do it
=SUMPRODUCT((C3:C73="U-19")*1,(G3:G73="Elton")*1)
Regards,
Per
|