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