VBA assistance with Application.WorksheetFunction.SumIf

[Sintek]

Hi All

I just can't get this right. I need to change this to a action.

Please Login or Register  to view this content.

i.e.

Please Login or Register  to view this content.

Please help

[Sintek]

Something like this:

Please Login or Register  to view this content.

[Sintek]

K, Think I got it working

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Sintek]

Hey guys

I still suck with this Type of code. please assist.

I have

Please Login or Register  to view this content.

I am trying to get this line to work

Please Login or Register  to view this content.

ws1.Range("C2:C10") has the following value

*coke zero*
*coke bottle*
*coke can*
*coke lite*
*fanta*
*grapetiser*
*sprite*
*appletiser*
*energade*

[Sintek]

Can anyone please help once and for all....