Hi All, I have used sumproduct formula in the attached file and it seems to be slowing down my file. I am aware of the work around steps like changing calculation to Manual, but i was wondering if there was a substitute formula that i can use, the spreadsheet will keep growing in size month by month
File link is
http://speedy.sh/453Sm/Sum-If-Query.xlsx
I was having trouble uploading this file on to this site's upload system