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]