I use SUMIFS function on my Mac Numbers. I wrote about this function in How to calculate summary with a condition on Numbers of Mac? - Shammerism, but I faced with the case SUMIFS doesn't calc if the range is not in the same sheet. SUMIFS …