Question Locked

EXCEL Subrotal Function

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a normal spreadsheet with numeric data across 7 columns and 50 rows. The columns are for "CLASSES" and the rows are for "Years". At the bottom of the columns I have a 'Totals" row and I used the Subtotal function to sum the "CLASSES" since I will be using a filter later. That works fine. At the end of each row I used the SUM function for the "Year's Total". That works fine. However, at the bottom of the "Year's Total" I also used the Subtotal function but it returns a 0. Why?

3 replies

by juliang

Thanks, but I'm affraid it didn't help since the link to the article about SUBTOTAL on their website is not correct.

This discussion is closed to new replies.