Sum range of rwos based on criteria

[donk04]

Hi to everyone.

I have an range A10:K50
there are plenty of information.
I need to sum the amount of column K if and only if the code in Column B starts with AB and in the column F finds the word Blue.
The header of column B is AccountCode and for F Size.

thanks in advance for your valuable time

Manos

[JohnTopley]

Please post a small sample file showing expected results.

[Kramxel]

in column L enter and dragdown

Please Login or Register  to view this content.

and then this formula whereever you need it

Please Login or Register  to view this content.

[Glenn Kennedy]

Try htis:
=SUMPRODUCT((LEFT($B$10:$B$50,2)="AB")*(ISNUMBER(SEARCH("blue",$F$10:$F$50)))*K10:K50)

[donk04]

Thanks a lot for your valuable help. Both ways work perfectly.

[Glenn Kennedy]

Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.