Hi
Hopefully someone can help here as I have drawn a complete blank!
I have a table with dates as headers. I want to sumif rows where the sum_range is dynamically referenced.
So this formula works...
=SUMIF(Rev_WK12[[#All],[ITEM]],A8,Rev_WK12[[#All],[30/03/2013]])
table name = Rev_WK12
A8 = Reference to what I am looking for.
[ITEM] = column header title
But I want to dynamically reference the column with the date in it. So I tried...
=SUMIF(Rev_WK12[[#All],[ITEM]],A8,INDIRECT("Rev_WK12[[#All],["&N8&"]]"))
N8 = contains the Date Text. The same as the Table column name.
I have also tried removing the INDIRECT...
=SUMIF(Rev_WK12[[#All],[ITEM]],A8,"Rev_WK12[[#All],["&N8&"]]")
All ideas gratefully received
Working with Excel 2012 on Win 7
Thanks
Aaron
Hopefully someone can help here as I have drawn a complete blank!
I have a table with dates as headers. I want to sumif rows where the sum_range is dynamically referenced.
So this formula works...
=SUMIF(Rev_WK12[[#All],[ITEM]],A8,Rev_WK12[[#All],[30/03/2013]])
table name = Rev_WK12
A8 = Reference to what I am looking for.
[ITEM] = column header title
But I want to dynamically reference the column with the date in it. So I tried...
=SUMIF(Rev_WK12[[#All],[ITEM]],A8,INDIRECT("Rev_WK12[[#All],["&N8&"]]"))
N8 = contains the Date Text. The same as the Table column name.
I have also tried removing the INDIRECT...
=SUMIF(Rev_WK12[[#All],[ITEM]],A8,"Rev_WK12[[#All],["&N8&"]]")
All ideas gratefully received
Working with Excel 2012 on Win 7
Thanks
Aaron