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

[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

 

[dguillett]

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 ) )