I read to post on how to put an OR function inside and IF function. I can't
get it to work when I try to put an OR function into my array-entered IF
function.

This is what I have now:

=IF(OR('datasheet'!F1:F520="c",'datasheet!F1:F520= "1"),'datasheet!A1:E520,"")

I'd like it to only bring the A:E data over to the summary sheet if the F in
the row of the datasheet is "c" or "___"(three underscores)...however it is
moving in all my data.

Can anyone tell me where I made a mistake, or if this is just not poossible.