Excel sumif with VBA

Hey community,

I try to calculate if E:E is not listed on AP:AP list are numbers, what am i doing wrong?

Please Login or Register  to view this content.

You refer to a Named Range List1 in VBA as Range("List1").

You probably also need to use Application.WorksheetFunction.SumIf(...)

Administrative Note:

• We would love to continue to help you with your query, but first, before we can proceed
• Please see Forum Rule #3 about Cross Posting and adjust accordingly.
• Also, please read A message to forum cross posters

Originally Posted by Akbarov

please close or delete this post

When you create a duplicate post we keep the first post and close the duplicate. That is what I have done here. Other posts are available at the later duplicate.