trying to use this formula:

SUMPRODUCT(($L$22:$L$1166={"1svc"})*($M$22:$M$1166 ))

Column L contains both text and numerical data. Using excel help, near
as I can tell it cannot read the column with both types being contained
within.


here is as far as I can get with "help":

-Microsoft Excel cannot translate the text into the correct data type.
Make sure the formula or function is correct for the required operand
or argument, and that the cells that are referenced by the formula
contain valid values. For example, if cell A5 contains a number and
cell A6 contains the text "Not available", the formula =A5+A6 will
return the error #VALUE!.-



???


--
redneck joe


------------------------------------------------------------------------
redneck joe's Profile: http://www.excelforum.com/member.php...o&userid=32570
View this thread: http://www.excelforum.com/showthread...hreadid=535222