M
mike in texas
I have a dynamic range named code_db. It is a single column which expands as
new codes are added. I want to sum a column which is offest 22 columns. For
Excel 2007 the following formula works fine:
=(SUMIFS(OFFSET(Code_db,0,22),Code_db,$U$3&M7,OFFSET(Code_db,0,9),"Water"))
I'm trying to make it compatible with Excel 2003 using sumproduct and
offsets, but keep getting "#Value" when I enter the formula
=SUMPRODUCT(--(OFFSET(Code_db,0,22)),--(Code_db=$U$3&M7),--(OFFSET(Code_db,0,9)="Water"))
Is it possible to use sumproducts and offsets?
Thanks for your help!
Mike
new codes are added. I want to sum a column which is offest 22 columns. For
Excel 2007 the following formula works fine:
=(SUMIFS(OFFSET(Code_db,0,22),Code_db,$U$3&M7,OFFSET(Code_db,0,9),"Water"))
I'm trying to make it compatible with Excel 2003 using sumproduct and
offsets, but keep getting "#Value" when I enter the formula
=SUMPRODUCT(--(OFFSET(Code_db,0,22)),--(Code_db=$U$3&M7),--(OFFSET(Code_db,0,9)="Water"))
Is it possible to use sumproducts and offsets?
Thanks for your help!
Mike