Prev: Can I freeze columns in a listbox
Next: problem with conditional formatting and VBA (excel 2007)
From: Friðrik Björgvinsson Fri�rik on 19 Mar 2010 05:28
=SUMIF(A2(LEFT(A2:A2966;9)):A2966;$K$1;I2:I2966)
or should it be
=SUMIF(LEFT(A2:A2966;9);$K$1;I2:I2966)
I'm using this formula for as you can see nearly 3000 rows, is there another
way of doing it?
From: Stefi on 19 Mar 2010 06:28
=SUMPRODUCT(--(LEFT(A2:A2966,9)=$K$1),I2:I29666)

--
Regards!
Stefi



„Friðrik Björgvinsson” ezt írta:

> =SUMIF(A2(LEFT(A2:A2966;9)):A2966;$K$1;I2:I2966)
> or should it be
> =SUMIF(LEFT(A2:A2966;9);$K$1;I2:I2966)
> I'm using this formula for as you can see nearly 3000 rows, is there another
> way of doing it?
From: Jacob Skaria on 19 Mar 2010 09:02
Try the below

=SUMIF(A2:A2966,$K$1 & "*",I2:I2966)

The above formula will sum the values in I2:I2966 if the first characters in
A2:A2966 are same as what is specified in cell K1. This works only for text
strings.

--
Jacob


"Friðrik Björgvinsson" wrote:

> =SUMIF(A2(LEFT(A2:A2966;9)):A2966;$K$1;I2:I2966)
> or should it be
> =SUMIF(LEFT(A2:A2966;9);$K$1;I2:I2966)
> I'm using this formula for as you can see nearly 3000 rows, is there another
> way of doing it?
 | 
Pages: 1
Prev: Can I freeze columns in a listbox
Next: problem with conditional formatting and VBA (excel 2007)