# How To Use Find IfError, Countifs & Sum Product Function Using Excel Spread Sheet

• Formulas

## FAQs

The array formula will be written as =SUM(IFERROR(A1:A8,0)). In this scenario, the IFERROR function is assessing the contents of cells A1:A8 and replacing the error value with zero if there is an error. The data are then added using the SUM function. Cell A11 is where you'll enter this function.

Type =SUMPRODUCT(C2:C5,D2:D5) and press Enter to build the formula using the sample list above. The results of multiplying each cell in column C by its corresponding cell in the same row in column D are totaled up. \$78.97 is the total cost of the groceries.

The IFERROR function is an Excel built-in function that is classified as a Logical Function. It can be used in Excel as a worksheet function (WS). The IFERROR function is a worksheet function that can be used in a formula in a worksheet cell.

## Recommended Courses

### Share With Friend

Have a friend to whom you would want to share this course?   ######    