rjeffday
New member
- Joined
- Jul 29, 2013
- Messages
- 2
- Reaction score
- 0
- Points
- 0
Hello All,
I am taking printer readings each month and would like to display a YEAR END total that displays a 'running total' in a cell. IE: Jun = 1 page printed, Jul = 3 pages printed --> Year End Total = 2 Pages.
I am unable to get a Year End Total to display in the proper cell unless Jan - Dec are filled with numeric values other than zero.
I am using the following formula: =(F5-E5)+(G5-F5)+(H5-G5)+(I5-H5)+(J5-I5)+(K5-J5)+(L5-K5)+(M5-L5)+(N5-M5)+(O5-N5)+(P5-O5)+('2014'!E5-'2013'!P5)
(To get a value for my December 2013 reading, I am subtracting the Dec 2013 value from the corresponding Jan cell on page 2014.)
My problem is that when I put a value of '1' in cell J5 and a value of 3 in cell K5, my YEARLY TOTAL cell, Q5, displays the value of zero instead of '2'.
I hope I have explained this problem in terms that can be understood.
Any help is appreciated as I am a novice when it comes to using Excel for advanced functions.
Thank you,
RJeffDay
I am taking printer readings each month and would like to display a YEAR END total that displays a 'running total' in a cell. IE: Jun = 1 page printed, Jul = 3 pages printed --> Year End Total = 2 Pages.
I am unable to get a Year End Total to display in the proper cell unless Jan - Dec are filled with numeric values other than zero.
I am using the following formula: =(F5-E5)+(G5-F5)+(H5-G5)+(I5-H5)+(J5-I5)+(K5-J5)+(L5-K5)+(M5-L5)+(N5-M5)+(O5-N5)+(P5-O5)+('2014'!E5-'2013'!P5)
(To get a value for my December 2013 reading, I am subtracting the Dec 2013 value from the corresponding Jan cell on page 2014.)
My problem is that when I put a value of '1' in cell J5 and a value of 3 in cell K5, my YEARLY TOTAL cell, Q5, displays the value of zero instead of '2'.
I hope I have explained this problem in terms that can be understood.
Any help is appreciated as I am a novice when it comes to using Excel for advanced functions.
Thank you,
RJeffDay