We use the "sumifs" function as an example of "total sales of advanced MS Office books in 20 12 years".

Select a cell, click Insert Function and select the sumifs function.

In the topic, we can see that there are two screening conditions, time and topic, and then we should skillfully use these two conditions. Because we want sales, we should select all the sales in "sum_range" for summary.

Select the sum of all the figures under the subtotal.

In the screening conditions, we first screen the title of the book. So, first choose the titles of all the books in the list.

What we require is the sales volume of "MS Office Advanced Application", so we should fill in "MS Office Advanced Application".

Next, you need to filter the time, similar to the title of the book. First, select all the dates under the dates in the table.

Since the time range of 20 12 is 201-1to 2012-12-31,the above conditions are filled in respectively in the function screening conditions.

Click "OK" to finish!