Hello,
I am using this formula to pull numbers based on a name in excel:
=SUM(SUMIF($D2:$D107,{"AR"},H2:H107))
This works fine for what I need it to do; however, when saving it and returning to it the next day, the formula changes to:
=SUM(SUMIF($D2:$D107,{0},J2:J107))
any reason why the naming get replaced by 0??
Thanks,
Bookmarks