SUMPRODUCT has mismatched range sizes error when sheet opened inGoogle Excel.
On Friday, November 7, 2014 3:42:38 AM UTC-6, wrote:
Hi There,
After uploading Microsoft excel sheet to Google excess, the below applied Sumproduct Syntax shows error (Error: SUMPRODUCT has mismatched range sizes. Expected row count: 1. column count: 1. Actual row count: 500, column count: 1.)
Sumproduct Syntax:
=SUMPRODUCT(SUBTOTAL(3,OFFSET(C4:C503,ROW(C4:C503)-MIN(ROW(C4:C503)),,1)),--(C4:C503=B1))
This works fine with Microsoft Excel. I read in some of the forums that Google excel doesn't read "--" codes.
Please help,
Thanks in advance,
Navneet
This is how it works there but why use google when excel is so much better.
=ArrayFormula( SUMPRODUCT( A2:A10 = D2 ; B2:B10 = E2 ) )
|