you are viewing a single comment's thread
view the rest of the comments
[–] 2 points 4 months ago

Pivot tables are great because they force people to put their data into tables.

Formulas suck. You only need sum. Everything is a sum, if you enter your data correctly in a table.

Want to substract? yes, that is a sum in which one of the numbers are negative. Multiply? Yes that is more sums.

What about IF statements then? No, no, no. Conditions are simply factors in a sumproduct.

Learn the keyboard shortcut for sum. It's the straight edge and compass of excel math.

  • source
  • parent