sum cells with criteria

G

Guest

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

Bob Phillips

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

--

HTH

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

William

Hi David

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

--
XL2002
Regards

William

(e-mail address removed)

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF where the criteria is 'if contains a string'? 5
Sum If with two ranges and condition 6
SUMIF with criteria "<>" & "=" 4
Average by Multiple Criteria. 2
sumif wildcard criteria 1
Excel Countifs/Sumproduct with mutil Or statement 3
Please explain this formula 2
Help in counting and summing cells based on multiple conditions 9

Top