SUMPRODUCT has mismatched range sizes error when sheet opened inGoogle Excel.
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 |
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 ) ) |
All times are GMT +1. The time now is 10:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com