A
A
Artyom N2015-10-17 15:27:54
excel
Artyom N, 2015-10-17 15:27:54

How to select cell values ​​from a range in excel?

Good afternoon!
I have a table like this in excel:

|     A      | B  |
-------------------
| 01.10.2015 |  5 |
| 02.09.2015 | -3 |
| 12.10.2015 | 20 |

It is necessary in one cell on the adjacent sheet to display the sum of all positive numbers from column B, if the date in column A falls in October. Dates may not be in order. Numbers can be positive or negative. The number of lines is not known in advance.
Can this be done with one formula?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Artyom N, 2015-10-17
@nobr

Formula:
For the formula to work, you need to press CTRL + SHIFT + ENTER instead of ENTER (this is how formulas apply to arrays).

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question