How can I link the "sumif" criteria to a cell? thks

  • Thread starter Thread starter Lauravila
  • Start date Start date
Simply refer to the cell that holds the criteria *if* it's a straight
comparison:

......A.....B.....C
1...x......1......x
2...y......2
3...x......4
4...x......2

=SUMIF(A1:A4,C1,B1:B4)

If the criteria uses an operator like "greater than" then:

......A.....B.....C
1...2......1......5
2...7......2
3...3......4
4...6......2

=SUMIF(A1:A4,">"&C1,B1:B4)
 
Kindly post your question in the message area, not in the subject line. The
subject line is intended for a brief key summary line on your query, the
message area is where you elaborate on your query, providing the full
descripts & sample data

Never, never leave the message area empty. If you do, responders using the
webpage CANNOT respond to you (due to a technical glitch)
 
You must log in or register to reply here.

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 CRITERIA PROBLEM 8
SUMIF using 2 cells that equal each other 1
SUMIF - how to enter a second criteria 1
SUMIF 2
How to create a criteria for blank cells in a SUMIF formula? 2
SUMIF Function 1
SUMIFS error 1
Using SUMIF and AND functions simultaneously 3

Back
Top