R
ryan.fitzpatrick3
I have a sumproduct equation which finds the respective numbers on one
sheet and pulls it into a designated location on another sheet. Now
the last variable the "'Pulled from Access'!$G$7:$G$5420)" normally
pulls a number (which makes sense because it a sumproduct formula),
but I now have text in this column, is there away to make this
equation pull a text, or whatever is in that cell over? Maybe this is
not the correct equation, can anyone help me with the correct equation
which has these criteria and pulls text as the end result?
=SUMPRODUCT(--(1*'Pulled from Access'!$B$7:$B$5420=Data!$A11),--
(1*'Pulled from Access'!$C$7:$C$5420=Data!$B11),--(1*'Pulled from
Access'!$I$7:$I$5420=MONTH(DATEVALUE(Data!D$10&" 1, 2007"))),--
('Pulled from Access'!$J$7:$J$5420=MID($I$8,3,2)),--('Pulled from
Access'!$H$7:$H$5420="R"),'Pulled from Access'!$G$7:$G$5420)
The equation basically is stating that if range B ='s (let say Ryan)
and range C ='s age, and range I ='s the month born and range J ='s
the year born and range H ='s right handed, then the G range will find
the correct match for this criteria. (this is an example. This
equation will find the correct match out of a huge list of names,
ages, months, year, etc etc and put it into a specific designated
location on another sheet. It works too, so the question is getting a
text instead of a number over on the G range).
ryan
sheet and pulls it into a designated location on another sheet. Now
the last variable the "'Pulled from Access'!$G$7:$G$5420)" normally
pulls a number (which makes sense because it a sumproduct formula),
but I now have text in this column, is there away to make this
equation pull a text, or whatever is in that cell over? Maybe this is
not the correct equation, can anyone help me with the correct equation
which has these criteria and pulls text as the end result?
=SUMPRODUCT(--(1*'Pulled from Access'!$B$7:$B$5420=Data!$A11),--
(1*'Pulled from Access'!$C$7:$C$5420=Data!$B11),--(1*'Pulled from
Access'!$I$7:$I$5420=MONTH(DATEVALUE(Data!D$10&" 1, 2007"))),--
('Pulled from Access'!$J$7:$J$5420=MID($I$8,3,2)),--('Pulled from
Access'!$H$7:$H$5420="R"),'Pulled from Access'!$G$7:$G$5420)
The equation basically is stating that if range B ='s (let say Ryan)
and range C ='s age, and range I ='s the month born and range J ='s
the year born and range H ='s right handed, then the G range will find
the correct match for this criteria. (this is an example. This
equation will find the correct match out of a huge list of names,
ages, months, year, etc etc and put it into a specific designated
location on another sheet. It works too, so the question is getting a
text instead of a number over on the G range).
ryan