GOOGLE SHEETS – Create a Pivot Table

Working Papers recreated in GOOGLE SHEETS

Here we’ve used the original Excel file uploaded to GOOGLE SHEETS. Initially we had an error in the translation of the SUMIF functions. However the formulas seem to work identically.

We then tested the PIVOT TABLE functions which seem to work equally well.