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 |
Error formula
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 |
All times are GMT +1. The time now is 07:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com