Software

Question

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

2 total posts (Page 1 of 1)  
+ Follow this Discussion ·
| 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
2 total posts (Page 1 of 1)  

Start or search

Related Forums