sum cells with criteria

[DAVID]

I want to do something like sumif(A1:A100,"<5",B1:B100). But now instead of
the constant 5 in the criteria I want to use a variable, means the value of
the cell C1. How can i DO IT?

[Bob Phillips]

=SUMIF(A1:A100,"<"&C1,B1:B100)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"DAVID" <[email protected]> wrote in message
news:[email protected]...
> I want to do something like sumif(A1:A100,"<5",B1:B100). But now instead
of
> the constant 5 in the criteria I want to use a variable, means the value
of
> the cell C1. How can i DO IT?

[William]

Hi David

=SUMIF(A1:A100,"<"&C1,B1:B100)

--
XL2002
Regards

William

[email protected]

"DAVID" <[email protected]> wrote in message
news:[email protected]...
| I want to do something like sumif(A1:A100,"<5",B1:B100). But now instead
of
| the constant 5 in the criteria I want to use a variable, means the value
of
| the cell C1. How can i DO IT?

[DAVID]

Thanks a lot Bob!

"Bob Phillips" wrote:

> =SUMIF(A1:A100,"<"&C1,B1:B100)
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "DAVID" <[email protected]> wrote in message
> news:[email protected]...
> > I want to do something like sumif(A1:A100,"<5",B1:B100). But now instead
> of
> > the constant 5 in the criteria I want to use a variable, means the value
> of
> > the cell C1. How can i DO IT?
>
>
>

[DAVID]

Thank you as well, William!

"William" wrote:

> Hi David
>
> =SUMIF(A1:A100,"<"&C1,B1:B100)
>
> --
> XL2002
> Regards
>
> William
>
> [email protected]
>
> "DAVID" <[email protected]> wrote in message
> news:[email protected]...
> | I want to do something like sumif(A1:A100,"<5",B1:B100). But now instead
> of
> | the constant 5 in the criteria I want to use a variable, means the value
> of
> | the cell C1. How can i DO IT?
>
>
>
>