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.
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.
Last edited by jeffreybrown; 12-14-2018 at 04:26 PM.
You refer to a Named Range List1 in VBA as Range("List1").
You probably also need to use Application.WorksheetFunction.SumIf(...)
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
I don't understand code works good i only added *(list3<>list4) i need to sum if list3 is not on list4
Any help please?
Any help please?
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
HTH
Regards, Jeff
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks