I have a workbook with twelve sheets (one/month); I'm using named ranges, but for the column formatted for currency, I get the Wrong Data Type error when I use the named range for that column.
Named Ranges; format
Amount: Currency
GL: Text
formula: =SUMIF(GL,A5,Amount)
Named Range Details: GL - Scope - Workbook; Refers to: =Apr:Mar!$l$5:$l$45
Amount - Scope - Workbook; Refers to: =Apr:Mar!$q$5:$q$45
Any comments welcomed
Bookmarks