Excel #CALC! error
A dynamic array formula returned an empty result, typically FILTER with no matching rows.
Why it appears
- No row meets FILTER’s condition.
- A LAMBDA on its own in a cell, without calling it.
How to fix it
- Add FILTER’s third argument for the empty case: =FILTER(A2:C9,C2:C9>100,"No results").
- Call the LAMBDA or use it inside MAP or BYROW.
Gives the error
=FILTER(A2:C11,C2:C11>50000)
Fixed
=FILTER(A2:C11,C2:C11>50000,"Sin resultados")
About Ads
This site uses Google AdSense to display ads. These ads help us keep WebHerramientas completely free. Ads are managed by Google and meet strict security and privacy standards.
Ads help us keep WebHerramientas free for everyone
Practice it
Solve the exercise on the sheet; it is checked instantly. See all lessons · Formula translator
FILTER
FILTER(range, condition) returns only the rows that meet the condition. The condition compares a whole column with a value, like B2:B11=F1, and is checked row by row.
In E3, show the sales (all three columns) for the region in F1.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Salesperson | Region | Amount | Region | North | |||
| 2 | Carmen | North | 18,500 | |||||
| 3 | Jorge | South | 4,200 | |||||
| 4 | Lucía | North | 3,900 | |||||
| 5 | Andrés | Central | 21,000 | |||||
| 6 | Paola | South | 17,800 | |||||
| 7 | Ricardo | North | 6,400 | |||||
| 8 | Elena | Central | 5,900 | |||||
| 9 | Mateo | North | 19,900 | |||||
| 10 | Sofía | West | 800 | |||||
| 11 | Diego | Central | 4,600 | |||||
| 12 |
Tip: while typing, click a cell or drag across several to insert their reference. F4 anchors the reference with $.
Frequently asked questions
- What does #CALC! mean in Excel?
- A dynamic array formula returned an empty result, typically FILTER with no matching rows.
- How do I get rid of the #CALC! error?
- Add FILTER’s third argument for the empty case: =FILTER(A2:C9,C2:C9>100,"No results"). Call the LAMBDA or use it inside MAP or BYROW.
- What is #CALC! called in Spanish Excel?
- Spanish Excel shows it as #¡CALC!.