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 …

I wrote about the way how to calculate summary with a condition on Google Spread Sheet at QUERY is very useful!!! - Shammerism. I looked for the way because I thought I would use Debian as usually, but I can't decided to replace my Mac OS …