Forum Discussion
I am unable to understand issue here
After taking help for Microsoft Community I prepared a worksheet so facilitate my work. Everything works fine in Excel without any issues whatsoever. https://docs.google.com/spreadsheets/d/1PY4bD...
https://1drv.ms/x/s!AuiHgL3BptqpySp4NpyAKKsOSx4D?e=yQONSb
Above is the One Drive link for the same excel file
And below is the formula which shows error in Google Sheets
"=ARRAY_CONSTRAIN(ARRAYFORMULA(SUMPRODUCT(('Master-Sheet'!$H$2:$H$2000:'Master-Sheet'!$H$2:$H$2000='Backend Data'!$K$4)*('Master-Sheet'!$M$2:$M$2000:'Master-Sheet'!$M$2:$M$2000='Backend Data'!$M$3))), 1, 1)"
Above is the One Drive link for the same excel file
And below is the formula which shows error in Google Sheets
"=ARRAY_CONSTRAIN(ARRAYFORMULA(SUMPRODUCT(('Master-Sheet'!$H$2:$H$2000:'Master-Sheet'!$H$2:$H$2000='Backend Data'!$K$4)*('Master-Sheet'!$M$2:$M$2000:'Master-Sheet'!$M$2:$M$2000='Backend Data'!$M$3))), 1, 1)"
Ramu2603 Well, I can't help you with that as I don't know anything about GS. Sorry.
- Thanks for taking a look @Riny van Eekelen .