Hello,
Say I have the following table
A B C D E F G H I J 1 ID Account Jan 2016 Search Criteria 1 2 1000 PL490 10 1000 1001 1002 1003 1004 1005 3 1001 PL491 20 Search Criteria 2 4 1002 PL492 15 PL49* 5 1003 PL492 25 6 1004 PL491 30 7 1005 PL490 35
I had the following 2 SUMPRODUCT formula, but neither gave the correct result.
Please Login or Register to view this content.
So may I ask how can I use the SUMPRODUCT that enables to take multiple search on the same column and on the other criteria search using a wild card?Please Login or Register to view this content.
Please note that using SUM and SUMIF array could work, but higher ups are finding the formula to be taking a long time to calculate and thus had been told to avoid using it completely!
Bookmarks