August 23, 2017
SUMPRODUCT(SUMIFS(qty,mode,"Cash",item,books)) the answer is 190
but is one more criteria is added to this ---
SUMPRODUCT(SUMIFS(qty,mode,"Cash",item,books,party,depots)) the answer is 100 which is incorrect
December 7, 2016
I found your issue very interesting so I have played around a bit. See the attached sheet to see my attempt to explain why you get 100 as the result. It is correct value as per Excel logic if you use SUMPRODUCT function. As you see in the sheet I would use DSUM function instead, as you will then get rid of the TRUE or FALSE values + you are trying to use your range as a database. In such scenarios I prefer to use the D* functions.
I don't know if this gives any answer to your issue, but hopefully so.
Most Users Ever Online: 57
Currently Browsing this Page:
Frans Visser: 210
mey tithveasna: 71
Anders Sehlstedt: 47
Dharan Prakash Mishra
Guest Posters: 1
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas