Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding numbers from other sheets?
I have 5 cells on 5 sheets to add numbers together giving me a total on the
6th sheet cell, that formula is working just fine. But I need to pull the total from 6th sheet cell into a 7th sheet giving me the total I have on the 6th sheet cell, but when I put in my formula to pull it into the 7th sheet it gives me one number less than what I need and I for the life of me figure out whats going wrong. my formula to pull the total into the 7th sheet for this is as follows: =SUM('[Totals]Grand Totals'!J2)+(D7)+(E7)+(F7)+(G7)+(H7)+(I7)+(J7)+(K7 )+(L7)+(M7)+(N7)+(O7)+(P7)-(D12)-(E12)-(F12)-(G12)-(H12)-(I12)-(J12)-(K12)-(L12)-(M12)-(N12)-(O12)-(P12) If more info is need just let me know. I tried to as clear as I could |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding numbers from other sheets?
I don' tknow hwat is wrong, but simplifing your formula may help
=SUM('[Totals]Grand Totals'!J2)+Sum(D7:P7)-Sum(D12:P12) "Unforgiving" wrote: I have 5 cells on 5 sheets to add numbers together giving me a total on the 6th sheet cell, that formula is working just fine. But I need to pull the total from 6th sheet cell into a 7th sheet giving me the total I have on the 6th sheet cell, but when I put in my formula to pull it into the 7th sheet it gives me one number less than what I need and I for the life of me figure out whats going wrong. my formula to pull the total into the 7th sheet for this is as follows: =SUM('[Totals]Grand Totals'!J2)+(D7)+(E7)+(F7)+(G7)+(H7)+(I7)+(J7)+(K7 )+(L7)+(M7)+(N7)+(O7)+(P7)-(D12)-(E12)-(F12)-(G12)-(H12)-(I12)-(J12)-(K12)-(L12)-(M12)-(N12)-(O12)-(P12) If more info is need just let me know. I tried to as clear as I could |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding numbers from other sheets?
or even
=SUM('[Totals]Grand Totals'!J2,D7:P7)-SUM(D12:P12) -- __________________________________ HTH Bob "Joel" wrote in message ... I don' tknow hwat is wrong, but simplifing your formula may help =SUM('[Totals]Grand Totals'!J2)+Sum(D7:P7)-Sum(D12:P12) "Unforgiving" wrote: I have 5 cells on 5 sheets to add numbers together giving me a total on the 6th sheet cell, that formula is working just fine. But I need to pull the total from 6th sheet cell into a 7th sheet giving me the total I have on the 6th sheet cell, but when I put in my formula to pull it into the 7th sheet it gives me one number less than what I need and I for the life of me figure out whats going wrong. my formula to pull the total into the 7th sheet for this is as follows: =SUM('[Totals]Grand Totals'!J2)+(D7)+(E7)+(F7)+(G7)+(H7)+(I7)+(J7)+(K7 )+(L7)+(M7)+(N7)+(O7)+(P7)-(D12)-(E12)-(F12)-(G12)-(H12)-(I12)-(J12)-(K12)-(L12)-(M12)-(N12)-(O12)-(P12) If more info is need just let me know. I tried to as clear as I could |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding numbers or characters to existing numbers | Excel Worksheet Functions | |||
Adding numbers from specific cells in a number of sheets | Excel Worksheet Functions | |||
Adding Sheets | Excel Discussion (Misc queries) | |||
Adding numbers to current numbers | Excel Worksheet Functions | |||
adding sheets together | Excel Programming |