a "SUMIF" question

  • Thread starter Thread starter Carol
  • Start date Start date
C

Carol

If I sum column A if the cell value is bigger then let's say 10, then I do
=SUMIF(A1:A100,">10", A1:A100), however, this doesn't work if the criteria is
in another cell. if I want to sum column A if its cell value is bigger than
the number in cell B1.

So, how can I sum column A if its cell value is bigger than the number in
cell B1?

Thanks!
 

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

Using SUMIF with AND 2
Please help with countif formula 4
How to use Indirect functions? 3
SUMIF with criteria "<>" & "=" 4
SUMIF by Week. 8
Array formula 3
Filtering with SUMIFS 1
Sumif less than x 3

Back
Top