Question

2. If the formula = C2 + $D$2 in cell E2 is copied to cell E3, the new formula in cell E3
will be
toto
= C3 + $E$3 ​

Answer 1

In this guide you are going to learn all about the Excel SUMIF function which is the most important Excel formula there is for summarizing your information (and also SUMIFS which will be tackled later).

Now the SUMIF is all about conditional summing, that is we only sum all numbers in a range based on one criterion. Aside from numbers, SUMIF can also add cells based on dates and text that match specific criteria. Logical operators can be utilized such as <, >, = and wildcards (*,?) for partial matching.

How to use SUMIF Function

SUMIF function’s syntax is:

=SUMIF(range, criteria, [sum_range])

Range – this is the range of cells that you want to apply the criteria against

Criteria – the criteria used to determine which cells to add

Sum_range – Optional, this is the range of cells to sum together. However, it uses the Range (1st argument) as the sum_range if this parameter is omitted.

Let us explore how to use the Excel SUMIF function:

Suppose we have a list of the quantity of our product (in this case, ribbon) and we want to sum all based on their colors. Below, you can see our data, formulas, and the results returned by our SUMIF formula.

I hope you are understand my solution

Answer 2

Answer:

In this guide you are going to learn all about the Excel SUM-IF function which is the most important Excel formula there is for summarizing your information (and also SUM-IFS which will be tackled later).

Now the SUM-IF is all about conditional summing, that is we only sum all numbers in a range based on one criterion. Aside from numbers, SUMIF can also add cells based on dates and text that match specific criteria. Logical operators can be utilized such as <, >, = and wildcards (*,?) for partial matching.

How to use SUM-IF Function

SUM-IF function’s syntax is:

=SUM-IF(range, criteria, [sum_range])

Range – this is the range of cells that you want to apply the criteria against

Criteria – the criteria used to determine which cells to add

Sum_range – Optional, this is the range of cells to sum together. However, it uses the Range (1st argument) as the sum_range if this parameter is omitted.

Let us explore how to use the Excel SUM-IF function:

Suppose we have a list of the quantity of our product (in this case, ribbon) and we want to sum all based on their colors. Below, you can see our data, formulas, and the results returned by our SUM-IF formula.

I hope you are understand my solution

Explanation:

plz mark as brainiest