I have a worksheet where I have created several named single-column ranges using the offset function, i.e. =OFFSET(Reformatted!$B$2,0,0,COUNTA(Reformatted!$B:$B),1). I created a sumifs formula using these named ranges and I get a #value error. If I use a standard criteria range of Reformatted!$B:$B, sumifs works just fine. Any ideas why? The sumif function doesn't seem to have the same limitation.
Last edited: