WorksheetFunction.SumIfs in vba doesn't work

Hi,

I have a problem with below function in my code. First line with code is working, but I wanted to make it smaller and after declaring, the second line with code isn't working:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Of course I've declared those two ranges:

Please Login or Register  to view this content.

Any ideas? :-)

deleted this response

Hi,

thanks for your response.

Alright, but now with the proper qualify of Cells and Rows the first code is still working but the second isn't:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Sure, the whole code is:

Please Login or Register  to view this content.

The steps with "Offset" were recorded by macro recorder, but I'm trying to change it, because I don't want to use Offset property.

Problem is solved. I made a stupid mistake, because while testing this I skipped directly to 'Create Formula part, so macro didn't see those two Set parameters:

Please Login or Register  to view this content.

Ehh, beginners difficulties... ;-)

Thanks again for help!