ExcelBanter - Easy solution need for find problem

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Easy solution need for find problem (https://www.excelbanter.com/excel-programming/342512-easy-solution-need-find-problem.html)

Neil Atkinson

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 ***

Dave Peterson

Easy solution need for find problem

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

All times are GMT +1. The time now is 03:03 PM.