jimbogarner
Board Regular
- Joined
- Apr 22, 2010
- Messages
- 102
Hi,
I've been using an index/match formula to select a cell within a grid dependant on the week, however, I now need this to pull in a YTD value, IE for week 21, sum up weeks 1 > 21... I currently have the following formula which it doesn't seem to like (i'm using google sheets);
=IFERROR(SUM(INDEX(KPIs!$V$2:INDEX(KPIs!$V$2:$BU$21,0,MATCH(Control!$C$3,KPIs!$V$1:$BU$1,0)),MATCH($A$9,KPIs!$U$2:$V$21,0),0)),"")
The below is the snip from the KPI sheet that the above is trying to sum from;
Thanks,
James
I've been using an index/match formula to select a cell within a grid dependant on the week, however, I now need this to pull in a YTD value, IE for week 21, sum up weeks 1 > 21... I currently have the following formula which it doesn't seem to like (i'm using google sheets);
=IFERROR(SUM(INDEX(KPIs!$V$2:INDEX(KPIs!$V$2:$BU$21,0,MATCH(Control!$C$3,KPIs!$V$1:$BU$1,0)),MATCH($A$9,KPIs!$U$2:$V$21,0),0)),"")
The below is the snip from the KPI sheet that the above is trying to sum from;
Thanks,
James