R
R
raffx2015-01-01 14:06:54
Google Sheets
raffx, 2015-01-01 14:06:54

How to compose a nested SUMIFS function in Google Spreadsheets?

Table:

-----A-----------------------------B 
1    26.12.2014 15:53:24        500 
2    26.10.2014 15:54:05        423 
3    26.12.2014 15:57:06        5000

Please tell me how to correctly compose this nested function:
=SUMIFS(B:B; MONTH(A:A); "10")
That is, sum columns B, in which the number of the month in A is 10. In this example, it should turn out 423, but instead it writes:
#VALUE! Error: Array arguments in SUMIFS function have different sizes.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
S
shavluk, 2015-01-02
@raffx

=SUMIFS(B:B; ARRAYFORMULA(MONTH(A:A)); "10")

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question