How to count the number of values in groups in Excel?

W

weranda2021-06-26 11:57:26

excel

weranda, 2021-06-26 11:57:26

Greetings.
There is such a table:

Where there are question marks, it is necessary to somehow calculate the number of plants included in the group. For example, in the herbaceous group, 625 plants should be obtained.
Suggest a solution.

PS
Wrong with the table. Updated it.

PPS The
question is solved through SUMMESLI.

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

D

Dmitry, 2021-06-26
@Tabletko

=ScoreIf

C

ComodoHacker, 2021-06-26
@ComodoHacker

pivot table