Error formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to do a sum if but I need to change the criteria several times and as
with sumif I can't use a cell reference as criteria, I thought using the
following formula:
sum( if ((range < $F$4), sum_range)).
I get the wrong answer, but when I go to "Insert, Function" the Formula
result is different from what I am getting in the spreadsheet and actually
the correct one!...

Has this happen to anyone before?
Thank you,
Laura
 
You can use a cell reference as a criterion. Ex: =sumif(a:a,"<"&F4,b:b)
will add all the cells from column B where the corresponding cell in column A
is less than the value in cell F4.
 
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 number is greater than a number but less than another number 2
Using autofill in Excel 2007 1
SUM & SUMIF formula problems 3
SUMIF with 2 ranges and 2 criteria's, totaling the same sum range. 10
Replace ; with , in functions 1
Sumif formula 4
SUMIF and INDIRECT reference to tab in other workbook 3
Using Indirect in a Sumif Function returns the wrong answer 4

Back
Top