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
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