Forum Discussion
Issue with converting Google Sheet into Excel
That means Google Sheets formula is not compatible with Excel. Google Sheets adds such combination with @__xludf.DUMMYFUNCTION and current static value returned by IFEEROR, in your sample 10, to avoid errors in file saved as Excel workbook.
If take one of such formulae, e.g. in D3
=IFERROR(@__xludf.DUMMYFUNCTION( "IFERROR(COUNTIF(FILTER({$C$13:$C$105}, {$E$13:$E$105}=$C3), ""<>""),0)" ),2)we may take second line
=IFERROR(COUNTIF(FILTER({$C$13:$C$105}, {$E$13:$E$105}=$C3), ""<>""),0)and try to transform it into correct Excel formula.
Here are two points - in Excel we don't need {} to transform range to array; and COUNTIF() doesn't work with array as first parameter, only with range.
Equivalent formula could be
=IFERROR( ROWS( FILTER($C$13:$C$105, ($E$13:$E$105=$C3)*($C$13:$C$105 <> "") ) ), 0 )It is in D1 in attached.
That means Google Sheets formula is not compatible with Excel. Google Sheets adds such combination with @__xludf.DUMMYFUNCTION and current static value returned by IFEEROR, in your sample 10, to avoid errors in file saved as Excel workbook.
If take one of such formulae, e.g. in D3
=IFERROR(@__xludf.DUMMYFUNCTION(
"IFERROR(COUNTIF(FILTER({$C$13:$C$105}, {$E$13:$E$105}=$C3), ""<>""),0)"
),2)we may take second line
=IFERROR(COUNTIF(FILTER({$C$13:$C$105}, {$E$13:$E$105}=$C3), ""<>""),0)and try to transform it into correct Excel formula.
Here are two points - in Excel we don't need {} to transform range to array; and COUNTIF() doesn't work with array as first parameter, only with range.
Equivalent formula could be
=IFERROR( ROWS( FILTER($C$13:$C$105, ($E$13:$E$105=$C3)*($C$13:$C$105 <> "") ) ), 0 )It is in D1 in attached.
Thank you, SergeiBaklan! Excel not needing the {} for arrays is what threw me off. Much appreciated!
gsquared2 , glad to help
