I have yet another burning question, this time regarding sumproduct. I am having problems getting my sumproduct formula to work, as they would show me a #value error when my referred range has null values.
Here is my sumproduct formula:
I am using a two dimensional sumproduct formula, which helps me detect which data belongs to that particular year (matching the year in D3) and sum up all those values.
Attached is a similar version of my main working file, however, i use index and match in my main working file to reference the data instead of isblank.
Is there anyone that could help me with this? Sorry if the explanation is rather bad.