Google Product Forums

Re: #NUM with arrayformula and year function


AD:AM Jun 26, 2012 4:28 AM
Posted in group: Google Docs

Categories: Sheets : Report an issue :

Hi ajarle, sorry I missed your post in the other thread.

Try:

=ARRAYFORMULA(SUMPRODUCT((IFERROR(MONTH(dato_beslutning))=A4)*(IFERROR(YEAR(dato_beslutning))=$B$1)*(vurdering=$E$2)*verdi))

or

=ARRAYFORMULA(SUM((IFERROR(MONTH(dato_beslutning))=A4)*(IFERROR(YEAR(dato_beslutning))=$B$1)*(vurdering=$E$2)*verdi))