i don't want it to count them twice.

That'll sum twice if C1 = x *and* E1 = x

=2*H1

--
Biff
Microsoft Excel MVP


"John C" <johnc@stateofdenial wrote in message
...
=SUMPRODUCT((LEFT(Xfers!C:C,6)="834097")+(LEFT(Xfe rs!E:E,6)="834097"),(Xfers!H:H))

Use the + (or) in your sumproduct. I am assuming that since you are using
whole column references that you have xl2007.

Hope this helps.
--
John C


"Eric D" wrote:

I currently have the following formula :

=SUMPRODUCT(--(LEFT(Xfers!C:C,6)="834097"),(Xfers!H:H))

which this works great for items occurring in column c, but i also need
it
to sum column H when column E's first 6 characters = 834097 but i don't
want
it to count them twice. So if column C and E match then it shouldn't sum
column H twice.

Can someone help me with this? Thanks
--
Eric