Hi all,
I am having an issue with both sumifs and countifs not working across linked workbooks if they are closed. I know that there is an issue in this aspect and have managed to solve my countif and sumif formulas with sum(if( / count(if( or sumproduct(1*( workarounds but, I am not sure how to do it for multiple criteria (or if it can even be done).
Any help would be great.
Bookmarks