Q. In MS-Excel what does SUMIF function do?

1. Adds up cell values based on a condition
2. Adds all the numbers in a range of cells
3. Returns a subtotal in a list or database
4. Both (1) & (2)