Hi,
I am constructing a SUMIFS formula but it doesn't display the correct value because of one criteria. That criteria is to match the long number in a range. Example criteria is: '123450000000012300. But it also summing up the criteria in a range with '123450000000012100 and 123450000000012200.
I tried to use the SUM(IF( array and it works but since I have to use the formula in more than 10 cells, I am getting an 'Out of memory' error message.
Hopefully not VBA solutions if this can be solve using formula.
Thank you.
Bookmarks