To calculate the Consumer Price Index between two years in Excel, take a sum of all the amounts spent ... with the CPI ratio and hit the percentage symbol. The same could be done over a range ...

You can sum up entire columns or rows in Microsoft Excel using the AutoSum feature. The AutoSum tool automatically selects a column or row of numbers, but you can select any set of numbers by ...