Ok here is a problem I am having:
I have a list of names in another sheet(Sheet 2). On another sheet (Sheet 1) I have 5 columns that some of the columns consist of various IF Statements. Depending on the letter that is put into A16 will determine the number that goes in G16 & I16. I need an additional formula (including what I already have in the cell) that says If H16,H17,H18,H19,H20 is grouped with name in F16 from the list on Sheet 2, then G16 = 0. Our scoring is this, If the "Person Speaking" (F16) recognizes only one person in H16 and that person is in the same group (or Team) from the list on Sheet 2, then they receive 0 points. If the "Person Speaking" (F16) recognizes more than one person then they get the points that are calculated based on the formula already in the cell. The "People being Recognized" are never effected regarding their points. Many thanks for any help. Below is the link https://docs.google.com/spreadsheet/ccc?key=0AkYvn9U2nf47dFpvVmlwQVMwUDAxem9EZ3RteHZtSkE&usp=sharing -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
