SUMPRODUCT and COUNTIFS are not interchangeable.
You might be able to substitute one for the other, but not without making significant changes.
How exactly are you changing the formula?
SUMPRODUCT and COUNTIFS are not interchangeable.
You might be able to substitute one for the other, but not without making significant changes.
How exactly are you changing the formula?
If posting code please use code tags, see here.
I just tried changing the sumproduct to countifs, as I do not know much about vba and formulas, what do you suggest. Thanks![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks