There is a major difference between SUMIFS and SUMPRODUCT functions in Google Sheets. The former is a conditional SUM function but the latter is to calculate the sum of the products that also in equal sized ranges. But you can use them in a similar way. SUMIFS or SUMPRODUCT, which one is better?

Visit the Learning Center. Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Another way to handle this problem is to do a "local" conditional sum on each sheet, then use a regular 3D sum to add up each value on the summary tab. To do this, add a SUMIF formula to each sheet sheet that uses a criteria cell on the summary sheet. Then when you change the criteria, all linked SUMIF formulas will update. I am using google sheets. I posted as well on the google products forum and some useful answers were proposed. I will answer my own question. Sounds like a good option for excel but I ditched excel years ago, the collaboration and cloud storage are just too important. – Catu May 7 '15 at 15:38 Jul 25, 2019 · The #ERROR! message is specifically unique to Google Sheets and what it means is that it cannot understand the formula that has been entered and therefore cannot execute the command to parse the data. Jul 25, 2019 · The #ERROR! message is specifically unique to Google Sheets and what it means is that it cannot understand the formula that has been entered and therefore cannot execute the command to parse the data. There is a major difference between SUMIFS and SUMPRODUCT functions in Google Sheets. The former is a conditional SUM function but the latter is to calculate the sum of the products that also in equal sized ranges. But you can use them in a similar way. SUMIFS or SUMPRODUCT, which one is better?

Google Sheets is similar to Excel and uses many of the same functions. Assuming you want to sum a range of values and have some criteria to either include or exclude, you can use the SUMIFS function. The SUMIF function returns the results in an array of summed values for each brand (criteria value) across multiple sheets. Finally, the SUMPRODUCT function sums all the values of this resulting array returned by the SUMIF function for each criteria value across multiple sheets.