79520993

Date: 2025-03-19 17:52:51
Score: 9 🚩
Natty: 4.5
Report link

=SUMPRODUCT(($B$19:$B$5589=B4),SUBTOTAL(109,OFFSET(M19,ROW($M$19:$M$5589)-ROW(M19),0)))

I have the same issue. both work in excel and not GS. The one above totals $$$, while below counts rows.

ErrorSUMPRODUCT has mismatched range sizes. Expected row count: 5483. column count: 1. Actual row count: 1, column count: 1.

=SUMPRODUCT(SUBTOTAL(3,OFFSET(B19:B5592,ROW(B19:B5592)-MIN(ROW(B19:B5592)),,1,)),N(B19:B5592=H4))

ErrorSUMPRODUCT has mismatched range sizes. Expected row count: 1. column count: 1. Actual row count: 5483, column count: 1.

I have been trying many versions of the formulas and no luck so far for two days. Any help? TY

Reasons:
  • Blacklisted phrase (1): Any help
  • Blacklisted phrase (1): I have the same issue
  • Blacklisted phrase (1): no luck
  • Long answer (-0.5):
  • No code block (0.5):
  • Me too answer (2.5): I have the same issue
  • Ends in question mark (2):
  • Unregistered user (0.5):
  • Low reputation (1):
Posted by: Tony Urbalejo