Thank you, however, the 3 underscores in the data sheet doesn't turn out a
TRUE for the formula. I switched it to "1" just to check and see if it was
the ___ that was the porblem and still nothing is carried over for the second
part of the OR statement. However, now it doesn't carry over all the data,
only the lines with "c".

"Tyro" wrote:

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.