Using Countif with non-specific value criteria

Hi I'm trying to figure out a method to use countif without specifically telling each cell what value it's looking for.

Example:
=IF($I$136<>"",SUMIF(NewSchedule!$K$6:$K$1000,"*129*",NewSchedule!$L$6:$L$1000),"")

This verifies that an entry has been made in I136, looks into K6:K1000 for values similar to 129 then adds the cells next to it in row L.
I'd like to be able to drag this formula and have it auto-adjust to different values.

129 corresponds to an order # and is located in cell A129 so I was hoping to be able to put
=IF($I$136<>"",SUMIF(NewSchedule!$K$6:$K$1000,"(value of A129)",NewSchedule!$L$6:$L$1000),"")

then be able to drag it down for the remaining orders
=IF($I$136<>"",SUMIF(NewSchedule!$K$6:$K$1000,"(value of A130)",NewSchedule!$L$6:$L$1000),"")

=IF($I$136<>"",SUMIF(NewSchedule!$K$6:$K$1000,"(value of A131)",NewSchedule!$L$6:$L$1000),"")

=IF($I$136<>"",SUMIF(NewSchedule!$K$6:$K$1000,"(value of A132)",NewSchedule!$L$6:$L$1000),"")

etc...

Otherwise I'll be here all day editing the cells manually.

Thank you!

Hi cdmse,

I think this may be what you are looking for:

Please Login or Register  to view this content.

That would execute the formula for values that are similar to the value in A129. As you copy the formula down, the A129 would advance to A130 and so on.

Hopefully that helps,

Dan

Awesome. Thanks Richard & Dan - Exactly what I was looking for.