View Single Post
  #1   Report Post  
David
 
Posts: n/a
Default IF(<criterion across sheets,1,0)?

Greetings
I'm trying to find a compact formula.
On sheet1 cell A1, I want to test that cells A1 on sheets 2 through sheet
102 contain text: "goat".
Has anyone thought of a compact formula? (maybe it's an array formula)
TIA for your responses.
--
David