How can I sum all the data in January example

Question

have a calendar that displays every profit and loss, but I want to figure out the fee, so how do I sum with the requirement that it be in January?

=SUMIF(MONTH(K2:K512),1,N2:N513)

I tried to use this formula did not work error

Answer 1

Your error is because your formula is invalid due to the fact that the first argument must be a range. In your example, that first argument is an array.