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.


"Lauravila" wrote:

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