__________ is the function which adds the cells as per given specified criteria.

SUMIF is the function which adds cells as per given specified criteria.

The SUMIF function adds values in a range that meet a specific condition.

Syntax: =SUMIF(range, criteria, [sum_range])

For example, to add sales amounts greater than ₹5,000:

=SUMIF(A2:A10, ">5000", B2:B10)

This checks the range A2:A10 for values greater than 5,000 and sums the corresponding values from B2:B10.

The other options serve different purposes:

• IF returns different values based on a condition (doesn't add cells)
• COUNTIF counts cells meeting criteria (doesn't sum them)
• WHATIF is not a standard spreadsheet function