Hi all,
I'm having issues getting an array to work that also excludes #N/A's.
Below is what I have attempted but neither have worked.
5:5 - Dates
6:6 - Numbers
D61 - Date of current month.
Attempt 1 - {=SUM(IF(AND(MONTH($5:$5)=MONTH(D$61),$6:$6<>#N/A),$6:$6))}
Attempt 2 - {=SUM(IF(IFERROR(MONTH(5:5)=MONTH(D$61),0),6:6))}
Thanks in advance for your help.
Bookmarks