SUMPRODUCT Question
Hi,
Using Excel 2003. Does the Sumproduct function work if the cells in a range are text? TIA |
SUMPRODUCT Question
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 |
SUMPRODUCT Question
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 |
All times are GMT +1. The time now is 09:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com