Skip to main content
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Sunday, 18 November 2018
  1 Replies
  7.7K Visits
0
Votes
Undo
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.
5 years ago
·
#1773
0
Votes
Undo
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.