EXCEL Subrotal Function

By juliang ·
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?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

This is a big read, i hope it helps you.

Please post back if you have any more problems or questions.

Collapse -

EXCEL Subtotal Function problem

by juliang In reply to This is a big read, i hop ...

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

Related Discussions

Related Forums