Average if certain text is present

[jlkirk]

I would like to average a range of cells on worksheet 1, column A, rows 1-100 if the text "Red" appears among other text in cell A1 on worksheet 2. Any ideas? Thanks in advance.

 

[njimack]

=IF(ISNUMBER(SEARCH("Red",Sheet2!A1)),AVERAGE(A1:A100),0)

 

[Aladin Akyurek]

I would like to average a range of cells on worksheet 1, column A, rows 1-100 if the text "Red" appears among other text in cell A1 on worksheet 2. Any ideas? Thanks in advance.

Do you mean?

=IF(ISNUMBER(SEARCH("Red",Sheet2!A1)),AVERAGE(Sheet1!A1:A100),"")

If not, care to elaborate?