V
V
Vlad2015-12-21 17:41:36
excel
Vlad, 2015-12-21 17:41:36

How to add Excel cells by month?

Hello.
I have 2 excel spreadsheets.
1 table of columns: Date, Name, Amount
2 table of columns: Month, Total amount
How can I correctly write the formula in the "Total amount" cell so that it automatically sums all the values ​​from the first table for the month indicated in the 1st column?
*I would like that in the 2nd table, the cells in the 1st row could be selected and multiplied in height, so that the formula would automatically adjust to all future months in order.
Help me please :(

Answer the question

In order to leave comments, you need to log in

1 answer(s)
M
Mercury13, 2015-12-21
@Mercury13

Now there is no access to Excel - dig towards the SUMIF function.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question