sum cells with criteria
 

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?

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

--

HTH

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


"DAVID" wrote in message
...
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?

Hi David

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

--
XL2002
Regards

William



"DAVID" wrote in message
...
| 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?

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" wrote in message
...
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?

Thank you as well, William!

"William" wrote:

Hi David

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

--
XL2002
Regards

William



"DAVID" wrote in message
...
| 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?