0
Undo
Votes
Hi everyone, I'm hoping for a little help please. I have a column of dates ("A") and a column of values ("D") and am trying to add values in column D based on month and year. I have a formula that does something although I cannot figure out the result it gives me. Maybe someone with more experience can give me a hand please?
Attached is a screenshot of my data. The formula I have is:
=SUMPRODUCT((MONTH(A2:A30)=6)*(YEAR(A2:A30)=2017)*(SUMIF(B2:B30,"<>#n/a")))
The actual result should be 1, which is simply the addition of the the values in cells for June 2017 in column B. The hard part seems to be ignoring those #N/A's.
Attached is a screenshot of my data. The formula I have is:
=SUMPRODUCT((MONTH(A2:A30)=6)*(YEAR(A2:A30)=2017)*(SUMIF(B2:B30,"<>#n/a")))
The actual result should be 1, which is simply the addition of the the values in cells for June 2017 in column B. The hard part seems to be ignoring those #N/A's.
0
Undo
Votes
In column D where you have your values, enter =IFERROR((ORIGINAL_FORMULA_IN_COLUMN_D),"") - This will get rid of the #N/A in column D
- Page :
- 1
There are no replies made for this post yet.