sumifs vs. Application.WorksheetFunction.SumIfs

Hello,

I have a data in 2 worksheets.
“Start” and “Import”

I have created a macro to replace the formula which was dragged in 20 rows



=(SUMIFS(Import!$H$3:$H$1000000;Import!$G$3:$G$1000000;">+" &B26;Import!$G$3:$G$1000000;"<=" & C26))


Macro is as follow.

Please Login or Register  to view this content.

When I have compared results between the formula and sumifs I have not get exactly the same results.

For example formula adds number and gives me number: 25, where the macro calculates 22.

Have I made a mistake somewhere in my macro?

flooyd

Hello,

it was a basic mistake. Thank you for pointing it out.

I have additional question. Is there a limitation for the sumifs macro?

I have corrected macro for example 3. I have noticed that if the difference (or the range between) is very small (in my example 0.2, formula calculates 1 second, where macro calculates 0.

Any idea why is that?
flooyd