Hi, Using Excel 2003. Does the Sumproduct function work if the cells in a range are text? TIA
J Jan Mar 30, 2009 #1 Hi, Using Excel 2003. Does the Sumproduct function work if the cells in a range are text? TIA
J Jacob Skaria Mar 30, 2009 #2 Yes.. Example given below ColA ColB cat red cat black cat black cat red cat black =SUMPRODUCT(--($A1:$A5="cat"),--($B1:$B5="black")) will give you the count of black cats
Yes.. Example given below ColA ColB cat red cat black cat black cat red cat black =SUMPRODUCT(--($A1:$A5="cat"),--($B1:$B5="black")) will give you the count of black cats
R ryguy7272 Mar 30, 2009 #3 Here are a few more examples: http://www.contextures.com/xlFunctions01.html http://www.contextures.com/xlFunctions04.html#SumProduct HTH, Ryan---
Here are a few more examples: http://www.contextures.com/xlFunctions01.html http://www.contextures.com/xlFunctions04.html#SumProduct HTH, Ryan---
