G
Guest
I used Max's formula and adjusted if for my data. The problem is because I
don't understand the formula I don't know what I'm doing wrong. The formula
Max sent was for only a few columns of data and my data has (E through FZ -
how many that is I don't have time to figure out). The table I want to sum
from is called "Data" and contains division initials in the first row (SO,
NW, NO, etc). I want to look at the division listed in F4 of a tab called
"Graph", evaluate the division code there and sum each var going down the
page based on which division it belongs to.
Max's formula -
SUM(OFFSET(Sheet1!$B$1,MATCH($A2,Sheet1!$A:$A,0)-1,,,MATCH(B$1,Sheet1!$1:$1,0)-1))
My formula -
=SUM(OFFSET(DATA!$E$2:$FZ$2,MATCH(Graph!$F$4,DATA!$E:$E,0)-1,,,MATCH(Graph!$F$4,DATA!$2:$2,0)-1))
My formula does summarize but only four columns of data and one of those
columns is not NW. Anybody know what I'm doing wrong or a better formula to
use. (I tried Julid D's which is also shown in the post but I couldn't
figure out how to adapt that one to my data)
DATA sheet
NW NW NW NS SO WT NW
var 40 40 20 10 10 3 40
Graph sheet
Division NW
var 140 (s/b based on above example)
don't understand the formula I don't know what I'm doing wrong. The formula
Max sent was for only a few columns of data and my data has (E through FZ -
how many that is I don't have time to figure out). The table I want to sum
from is called "Data" and contains division initials in the first row (SO,
NW, NO, etc). I want to look at the division listed in F4 of a tab called
"Graph", evaluate the division code there and sum each var going down the
page based on which division it belongs to.
Max's formula -
SUM(OFFSET(Sheet1!$B$1,MATCH($A2,Sheet1!$A:$A,0)-1,,,MATCH(B$1,Sheet1!$1:$1,0)-1))
My formula -
=SUM(OFFSET(DATA!$E$2:$FZ$2,MATCH(Graph!$F$4,DATA!$E:$E,0)-1,,,MATCH(Graph!$F$4,DATA!$2:$2,0)-1))
My formula does summarize but only four columns of data and one of those
columns is not NW. Anybody know what I'm doing wrong or a better formula to
use. (I tried Julid D's which is also shown in the post but I couldn't
figure out how to adapt that one to my data)
DATA sheet
NW NW NW NS SO WT NW
var 40 40 20 10 10 3 40
Graph sheet
Division NW
var 140 (s/b based on above example)