"Array Arguments Are of Different Size" Error
What it means: Two (or more) ranges in the same operation have mismatched sizes, so Google Sheets cannot pair their cells one-to-one.
Quick fix
=ARRAYFORMULA(A2:A100 * B2:B100)
Make both ranges the same height (A2:A100 and B2:B100, not A2:A100 and B2:B50). Equal row counts are required for element-by-element math.
Why you see #VALUE! — and how to fix each cause
1. The two ranges have different row counts
=A2:A100 * B2:B50 cannot multiply because one side has 99 rows and the other 49. Each cell needs a partner.
Fix: Extend the shorter range so both cover the same rows.
=ARRAYFORMULA(A2:A100 * B2:B100)
2. Mixing a whole column with a fixed range
=A:A * B2:B100 mixes an open-ended column (A:A) with a bounded range, so their sizes differ.
Fix: Bound both the same way, either both open or both to the same last row.
=ARRAYFORMULA(A2:A1000 * B2:B1000)
3. FILTER condition does not match the data height
FILTER(A2:A100, B2:B90>0) fails because the source column and the condition column cover different rows.
Fix: Use the same row span for the data and every condition.
=FILTER(A2:A100, B2:B100>0)
4. A horizontal range combined with a vertical one
Multiplying a row (A1:D1) by a column (A1:A4) mismatches shape, not just length.
Fix: Transpose one side with TRANSPOSE() or rebuild both in the same orientation.
Before and after
| Broken | Working |
|---|---|
=ARRAYFORMULA(A2:A100 * B2:B50) |
=ARRAYFORMULA(A2:A100 * B2:B100) |
Both ranges now span rows 2 through 100, so every cell has a matching partner.
How to stop it happening again
Keep paired ranges identical in both height and shape. When you are unsure how far the data goes, pick one generous last row (for example row 1000) and use it on every range in the formula. For conditions, reference the same rows as the data they filter.
FAQ
What does "array arguments are of different size" mean?
It means two ranges in your formula have a different number of rows or columns, so Sheets cannot line up their cells to calculate.
How do I fix different-size array arguments?
Make every range in the formula cover exactly the same rows and columns — for example A2:A100 and B2:B100, never A2:A100 and B2:B50.
Why does it happen with ARRAYFORMULA?
ARRAYFORMULA applies math cell-by-cell across ranges, so each range must be the same size or the pairing fails.
Can I mix a full column with a fixed range?
No — A:A and B2:B100 have different sizes. Bound both the same way so their row counts match.
→ Google Sheets formulas cheat sheet — 34 copy-paste formulas