Thanks, I think the 2 formulas will work just didn't know if there was a shorter way.
M mikeeee Oct 19, 2004 #1 Thanks, I think the 2 formulas will work just didn't know if there was a shorter way.
M Max Oct 19, 2004 #2 Just another option to try .. Put the elements you want checked i.e.: "no info", "11th", "12th" etc (without the quotes) into a named range, say: TBL Then try: =SUMPRODUCT(--NOT(ISNA(MATCH(TRIM('CONTROL GROUP 3'!H6:H313),TBL,0))))
Just another option to try .. Put the elements you want checked i.e.: "no info", "11th", "12th" etc (without the quotes) into a named range, say: TBL Then try: =SUMPRODUCT(--NOT(ISNA(MATCH(TRIM('CONTROL GROUP 3'!H6:H313),TBL,0))))
