Loop sumif VBA

[hommer]

hi guys, i have the below code for sumif function

however, is there a cleaner way to loop this through to the last filled cell in column A instead of listing many lines like below? Thanks.

Please Login or Register  to view this content.

[Andy Pope]

no need for a loop.

Please Login or Register  to view this content.

[hommer]

Hi Andy, that works perfectly but then i just notice that my sumif function only return the first number of the criteria rather than returning the sum of the total range in sheets("FRUIT").range("L:L"). can you see if my sumif is wrong?

basically my data is in sheet Fruit between column A to AD and the criteria is in sheet Data2, column A, the column im trying to sum up is sheet Fruit column L, am i missing something here? Thanks.

[Andy Pope]

You need to post example workbook. Include the actual formula you are trying to do via code so we can see expected formula and result.

[hommer]

Sure, i have amended my code and try to incorporate into the one you did but didnt work, my code below, tx

Please Login or Register  to view this content.

[Andy Pope]

Can you not post a example workbook?

[hommer]

sure, i have amended my code below

Please Login or Register  to view this content.

[Andy Pope]

how does that help with me understand what values are in myrg1 or myrg2 or what the result should be and what it actually is now?

[hommer]

Apols, pls see updated code and attached file, thx

Please Login or Register  to view this content.

[hommer]

with attachment

[Andy Pope]

Here is the modified code to replicate your example file.

Please Login or Register  to view this content.