SUMIF - formula not workimg?

[itr674]

Trying to sum column K9:K100 if the left 2 characters in column B9:B100 equal 3Y.

Whats wrong with the formula?

SUMIF('test'!B9:B100,LEFT(2,"3Y"),'test'!K9:K100)
This message was edited by em on 2002-10-18 13:47

 

[sam_d1]

Try the following...

>>Step 1.
In cell C9 enter "=LEFT(B9,2)" [with out " & ")
>>Step 2.
Drag it down till C100.

>> Step 3.
Use the following formula
=SUMIF(C9:C100,"3Y",K9:K100)

HTH
- sam

 

[Aladin Akyurek]

On 2002-09-25 01:15, em wrote:
Trying to sum column K9:K100 if the left 2 characters in column B9:B100 equal 3Y.

Whats wrong with the formula?

SUMIF('test'!B9:B100,LEFT(2,"3Y"),'test'!K9:K100)

=SUMPRODUCT((LEFT('test'!B9:B100,2)="3Y")*('test'!K9:K100))

 

[yosi]

don't need Left function

=SUMIF(A:A,"3y*",B:B)

 

[itr674]

all worked - thanks a bunch ...