=SUMPRODUCT((LEFT(E6:E11,2)="1s")*(I6:I11))

Maybe try instead:

=SUMPRODUCT(--(LEFT(E6:E11,2)="1s"),I6:I11)

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"JDT" wrote in message
...
On Mon, 03 Jan 2005 02:16:28 +0100, Aladin Akyurek
wrote:

What is the SumProduct formula you tried and what is intended to
calculate?

JDT wrote:
I want to do a sumproduct calculation, but it won't work because one
of the columns of data has formulas in it as well as blank rows.

I took the formulas out and just used the data and it worked, but with
the formulas in there I get an error message.

Is there any way do this? If you need more info, let me know.

Thanks.

=SUMPRODUCT((LEFT(E6:E11,2)="1s")*(I6:I11))

The "E" column has no formulas within it, but the "I" column has
formulas and both columns have blank rows. This formulas works fine
if I just use it up to the blank rows, but if I try and use more data
it doesn't work. I get the #Value! error.