__________ is the function which adds the cells as per given specified criteria.
- AWHATIF
- BIF
- CCOUNTIF
- DSUMIF
Solution & Step-by-step Explanation
In spreadsheets:SUMIF adds the values in a range that meet a specific, designated criterion.COUNTIF counts the number of cells that meet a criterion.IF performs a conditional logical test.Therefore, the function that adds cells based on specific criteria is SUMIF.