Hi all,

Recently, I have problems with getting my SUMPRODUCT formula to work.

Here is my formula:

=SUMPRODUCT((YEAR(J3:J1186)=N3)*(K3:K1186))

I am using this formula to help me sum all the values in a particular year. I had made sure the ranges have the same dimensions and that they are all of the same format.

[SIZE=13px]J3:J1186 is the range of the column containing the dates (all are in the dd/m/yyyy format, an example of a date is 15/1/2018).

N3 is the cell containing the year I want (eg 2018).

K3:K1186 is the range of values that I want to sum based on the year of the date column (J3:J1186). All of the values are in the number format. This range of values have 0 inside, which is what I am suspecting to cause the error.

Is there anyone that could help me with this error?

Thank you and have a nice day

~Hestia[/SIZE]