How to use the functions in excel to count the number of commodity categories?

This function can count the number of product categories, such as: = SUMPRODUCT ((a1:a100 = "Zhang San") * (B 1: B 100 = "washing machine")), and find that column A is Zhang San.

1. Open Excel 2007, create a data table of gender statistics, and prepare relevant data. As shown in the figure below:

2. Enter the formula =countif () in the cell after the gender "male". As shown in the figure below:

3. In the brackets of formula (), select the relevant data under gender. As shown in the figure below:

4. Comma, separate and select the "male" cell, and then press Enter. As shown in the figure below:

5. The number of girls is the same as that of boys (just change the cell behind the comma and select girls). As shown in the figure below:

6. If the gender data is locked, it is more convenient to drop it down (for example, $A$ 1). As shown in the figure below:

Brief introduction of North Book City

How to log in to the library of China West Normal University?

Problems in the Library of Shandong University of Technology

Dreaming of ghosts in the school library is a sign of fire.

Detailed location and opening hours of the study room in Beijing Library.

Is Hefei Library open for free?

First and Last Bus Timetable of Shanghai Metro 10 Line

Introduction of pinghu city Donghu Middle School

Is Zhengzhou Dennis shopping card fake?

I have a good habit of writing 290-word compositions.