Forum Discussion
What to use in place of "Google Sheets function ARRAYFORMULA" in Excel
1 Reply
If you have Microsoft 365 or Office 2021, every formula in Excel is automatically an array formula, so you can simply omit ARRAYFORMULA. For example,
=ARRAYFORMULA(SUM(IF(A1:A10>5, A1:A10, 0)))
becomes
=SUM(IF(A1:A10>5, A1:A10, 0))
If you have an older version, use
=SUM(IF(A1:A10>5, A1:A10, 0))
too, but confirm it by pressing Ctrl+Shift+Enter.
P.S. This is just for illustration; I know it would be easier to use SUMIF or SUMIFS.
