Prev: SUMIF function
Next: calcuate bond yields
From: Joseph on 11 Feb 2005 18:10
i want to do a conditonal sumif only searching on the first 13 characters of
the items in the list. ie. "Total Revenue" of what might be "Total
Revenue - All SE Accounts"

How can I use a variable instead of a fixed value to search on?

Any ideas on how I might be able to do this?

Thanks in advance.

Joe


From: Steve on 11 Feb 2005 18:22
Using what I leaned from a previous message this morning:
=SUMPRODUCT((LEFT(H2:H5,13) = "total Revenue")*(I2:I5))

"Joseph" <jmyonek(a)corsolutions.com> wrote in message
news:OsQgy5IEFHA.1600(a)TK2MSFTNGP10.phx.gbl...
>i want to do a conditonal sumif only searching on the first 13 characters
>of
> the items in the list. ie. "Total Revenue" of what might be "Total
> Revenue - All SE Accounts"
>
> How can I use a variable instead of a fixed value to search on?
>
> Any ideas on how I might be able to do this?
>
> Thanks in advance.
>
> Joe
>
>


From: Sandy Mann on 11 Feb 2005 18:25
As with the SUMIF question asked a few minutes ago try:


=SUMPRODUCT((LEFT(F1:F10,13)="Total Revenue")*(G1:G10))


HTH

Sandy
--
to e-mail direct replace @mailinator.com with @tiscali.co.uk


"Joseph" <jmyonek(a)corsolutions.com> wrote in message
news:OsQgy5IEFHA.1600(a)TK2MSFTNGP10.phx.gbl...
> i want to do a conditonal sumif only searching on the first 13 characters
of
> the items in the list. ie. "Total Revenue" of what might be "Total
> Revenue - All SE Accounts"
>
> How can I use a variable instead of a fixed value to search on?
>
> Any ideas on how I might be able to do this?
>
> Thanks in advance.
>
> Joe
>
>


From: Aladin Akyurek on 11 Feb 2005 18:31
=SUMIF(ItemRange,"Total Revenue*",SumRange)

Joseph wrote:
> i want to do a conditonal sumif only searching on the first 13 characters of
> the items in the list. ie. "Total Revenue" of what might be "Total
> Revenue - All SE Accounts"
>
> How can I use a variable instead of a fixed value to search on?
>
> Any ideas on how I might be able to do this?
>
> Thanks in advance.
>
> Joe
>
>
 | 
Pages: 1
Prev: SUMIF function
Next: calcuate bond yields