I have a sumifs formula that is linked to another workbook which returns error when workbook is closed. Apparently this is an error with excel and i should break it up into sum and multiple if's... I am struggling to do this so would appreciate some help for alternative formula to my current one below:
=SUMIFS(sum_range,range1,D2,range2,="Active",range3,<>"Opp")
Thanks![]()
Bookmarks