PDA

View Full Version : Solved: Sumproduct Text Value



khalid79m
02-10-2009, 04:20 AM
=SUMPRODUCT(--(SiteCalls!$B$3:$B$30000=AnalysisData!$B3)*(SiteCalls!$G$3:$G$30000=Analysi sData!$G3)*(SiteCalls!$L$3:$L$30000=AnalysisData!$L3)*(SiteCalls!$X$3:$X$30 000))

Hi this is my formula, it works great for getting a number value, but in this instance x3:x30000 has words in (TEXT) and I want it to return the TEXT instead it returns #Value!

Can anyone help?

Bob Phillips
02-10-2009, 04:55 AM
What do you mean by return the text? SUMPRODUCT by its ver
y nature, and name, sums the product of numbers.

khalid79m
02-10-2009, 05:24 AM
I know sumproduct , sums,

I need somthing to check the columns for the various criterias, and return me the text value it finds. if that makes sense. All records are unique.

Bob Phillips
02-10-2009, 06:18 AM
Then you don't want SUMPRODUCT

=INDEX(SiteCalls!$X$3:$X$30000,
MATCH(1,(SiteCalls!$B$3:$B$30000=AnalysisData!$B3)*(SiteCalls!$G$3:$G$30000 =AnalysisData!$G3)*(SiteCalls!$L$3:$L$30000=AnalysisData!$L3),0)

khalid79m
02-11-2009, 08:01 AM
thanks mate , worked good

mdmackillop
02-11-2009, 11:05 AM
Don't forget to mark your threads "solved"