Put this array formula in A1:E1, for example, on sheet1 and copy down
through row 520.
I changed the test for "1" to "___", 3 underscores as this is what you said
you want.

=IF(OR(datasheet!F1="c",datasheet!F1="___"),datash eet!A1:E1,"")

Tyro

"veggies27" wrote in message
...
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.