Hi,

Using Excel 2003. Does the Sumproduct function work if the cells in a range
are text?

TIA

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

--
If this post helps click Yes
---------------
Jacob Skaria


"Jan" wrote:

Hi,

Using Excel 2003. Does the Sumproduct function work if the cells in a range
are text?

TIA

Here are a few more examples:
http://www.contextures.com/xlFunctions01.html
http://www.contextures.com/xlFunctio...tml#SumProduct

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Jacob Skaria" wrote:

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

--
If this post helps click Yes
---------------
Jacob Skaria


"Jan" wrote:

Hi,

Using Excel 2003. Does the Sumproduct function work if the cells in a range
are text?

TIA