Error formula
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
|