You can force an error like `#DIV/0!`

and then use `IFERROR`

, e.g.

`=IFERROR(1/(1/SUMIFS_formula),"")`

### Related Contents:

- How to create a string or formula containing double quotes in Excel?
- Shortcut to Apply a Formula to an Entire Column in Excel [closed]
- Return empty cell from formula in Excel
- Check whether a cell contains a substring
- Excel: last character/string match in a string
- How to keep one variable constant with other one changing with row in excel
- Find last used cell in Excel VBA
- How can I perform a reverse string search in Excel without using VBA?
- IF statement: how to leave cell blank if condition is false (“” does not work)
- Simple Pivot Table to Count Unique Values
- Remove leading or trailing spaces in an entire column of data
- Excel Date to String conversion
- Excel formula to reference ‘CELL TO THE LEFT’
- Get content of a cell given the row and column numbers
- How do I recognize “#VALUE!” in Excel spreadsheets?
- Ignore Duplicates and Create New List of Unique Values in Excel
- Getting unique values in Excel by using formulas only
- Using “If cell contains #N/A” as a formula condition.
- Substring in excel
- Declaring variables in Excel Cells
- Sum up a column from a specific row down
- How does one sum only those rows in excel not filtered out?
- How do I reference a cell within excel named range?
- Pass row number as variable in excel sheet
- Format numbers in thousands (K) in Excel
- IF a cell contains a string
- In Excel, sum all values in one column in each row where another column is a specific value
- Excel compare two columns and highlight duplicates
- How to loop in excel without VBA or macros?
- How to disable Excel’s automatic cell reference change after copy/paste?
- Excel how to find values in 1 column exist in the range of values in another
- Using the value in a cell as a cell reference in a formula?
- Return values from the row above to the current row
- Generating CSV file for Excel, how to have a newline inside a value
- Freezing Row 1 and Column A at the same time
- Microsoft Excel ActiveX Controls Disabled?
- Parsing an ISO8601 date/time (including TimeZone) in Excel
- Check if the file exists using VBA
- Are ActiveX Controls Disabled?
- Excel cell from which a Function is called [duplicate]
- Properly Handling Errors in VBA (Excel)
- “Out of Memory Error (Java)” when using R and XLConnect package
- MS Excel – Concat with a delimiter
- Concatenating date with a string in Excel
- Use string value from a cell to access worksheet of same name
- Remove #N/A in vlookup result
- Does the VBA “And” operator evaluate the second argument when the first is false?
- Border around each cell in a range
- Is it possible to replace Excel’s VBA Editor/IDE with a modern alternative? [closed]
- Run Excel Macro from Outside Excel Using VBScript From Command Line