Can someone assist me with a formula to sumproduct with wildcards, please?
=SUMPRODUCT(--(F:F="NPT*"),--(A:A="PC*"))
I've got this but it doesn't work!!
--
Mark
Can someone assist me with a formula to sumproduct with wildcards, please?
=SUMPRODUCT(--(F:F="NPT*"),--(A:A="PC*"))
I've got this but it doesn't work!!
--
Mark
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks