Question

Give the syntax of SUM and SUMIF​

Answer 1

Answer:

For example, the formula =SUMIF(B2:B5, "John", C2:C5) sums only the values in the range C2:C5, where the corresponding cells in the range B2:B5 equal "John." To sum cells based on multiple criteria, see SUMIFS function

Answer 2

$\huge\boxed{\dag\sf\red{ANSWER}\dag}$

Syntax

= SUMIF

• (range, criteria, [su_ range])

Syntax

= SUM

• (number1, [number2], [number3],..)

$\huge\boxed{\dag\sf\red{Thanks}\dag}$