Software

Question

Gravatar
0 Votes
Locked

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

gravatar
Collapse -

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

by Peconet Tietokoneet-217038187993258194678069903632 In reply to EXCEL Subrotal Function

http://www.excel-it.com/excel_functions.htm

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

gravatar
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.

Back to Software Forum

Start or search

Related Discussions

Related Forums