SUMPRODUCT has mismatched range sizes error when sheet opened inGoogle Excel.

  • Thread starter Thread starter asianroutes.rpm
  • Start date Start date
A

asianroutes.rpm

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
 
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
Click to expand...

This is how it works there but why use google when excel is so much better.

=ArrayFormula( SUMPRODUCT( A2:A10 = D2 ; B2:B10 = E2 ) )
 
Back
Top