Easy solution need for find problem

Hi I need a code that will search through row 4 from B to DZ that will
find all the desciptions that contain the words "Travel Pack" amongst
their wording then will add up the qty listed in row 5 beneath!

Hope this makes sense...

Regards
Neil


*** Sent via Developersdex http://www.developersdex.com ***

maybe...

=SUMIF(B4:DZ4,"*travel pack*",B9:DZ9)




Neil Atkinson wrote:
>
> Hi I need a code that will search through row 4 from B to DZ that will
> find all the desciptions that contain the words "Travel Pack" amongst
> their wording then will add up the qty listed in row 5 beneath!
>
> Hope this makes sense...
>
> Regards
> Neil
>
> *** Sent via Developersdex http://www.developersdex.com ***

--

Dave Peterson