Selecting values ​​in a table?

Question

excel

Guys, tell me how to select values ​​from the table, and summarize them in certain cells by category?
Thanks in advance.

Answer 1

There are many ways. Alternatively - SUMIF(range, condition, [sum_range]
) in your example in cell i8:
=SUMIF($E:$E, $h8, $d:$d)-SUMIF($E:$E, $h8, $c:$c)
The first sumif sums all cells in the column D (receipt), for which the value in column E of the same row is equal to the value of the cell in column H to the left of the formula. The second sumif does the same but sums the cells in column c (expense). As a result, the entire income for the position is summed up, the entire expense for the position is subtracted from it - as far as I understand, this is exactly what is needed. If you just need to sum the income or expense by the criterion, just take the first or second half of the formula.
For row 8 of the table (No. p / p 7), the above formula will lie in cell I8, the selection criterion will be taken from H8, respectively; dragged down to cell I9, the formula will take the criterion from H9, and so on.

Answer 2

Array formulas