D
D
Daniyar Kudaibergenov2019-03-05 15:00:37
excel
Daniyar Kudaibergenov, 2019-03-05 15:00:37

How to calculate the sum of four columns whose rows match given criteria?

Tell me the formula - you need to calculate the amount of money spent on a specific expense item for a certain period. The picture is clearer5c7e64e1427e2557905666.png

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Anton Kiselyov, 2019-03-05
@CircleAndSqaure

Two options
1. =SUMIF() or =SUMIFS()
2. Pivot table
Upd. From the comments

B
BasiC2k, 2019-03-18
@BasiC2k

The third option is a custom formula in VBA. Those. the cell contains a formula of the form =MYCALCULATION() , and in the VBA code a function is written that calculates based on the specified parameters and the desired algorithm.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question