Live Chat & Podcast at 1:00PM Eastern on Sunday!
There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
Search
Business Applications
Tag Cloud
access acer asus batch bios bsod computer crash desktop driver drivers error ethernet excel freeze gaming gpu hard drive hardware hdmi internet laptop malware memory modem monitor motherboard network printer problem ram registry router slow software sound trojan ubuntu 11.10 uninstall usb video virus vista wifi windows windows 7 windows 7 32 bit windows 7 64 bit windows xp wireless
Search
Search for:
Tech Support Guy Forums > Software & Hardware > Business Applications >
Solved: Excel 2007 Seeking subtotals HELP

Reply  
Thread Tools
blaircj's Avatar
Junior Member with 7 posts.
 
Join Date: Jul 2008
Experience: Beginner
17-Jul-2008, 10:12 AM #1
Question Solved: Excel 2007 Seeking subtotals HELP
Hi I've got a question, I've designed a Excel Spread sheet to input data into continuous columns ( with the help of Bomb21's Sample excel file). But now that the list of entries are entered and sorted i was wondering if there is a simply command that can find subtotals that I've divided up, by their category and input that number into a formula on the fallowing sheet. I'm fairly new at all this Excel complex operations, so any help would be greatly appreciated.
Aj_old's Avatar
Computer Specs
Senior Member with 869 posts.
 
Join Date: Sep 2007
Location: Moldova
Experience: Intermediate
17-Jul-2008, 11:16 AM #2
Hi blaircj, you have double posted! Delete one of two threads!
Aj_old's Avatar
Computer Specs
Senior Member with 869 posts.
 
Join Date: Sep 2007
Location: Moldova
Experience: Intermediate
17-Jul-2008, 11:22 AM #3
Could you post a sample file?
blaircj's Avatar
Junior Member with 7 posts.
 
Join Date: Jul 2008
Experience: Beginner
17-Jul-2008, 12:00 PM #4
Question Sample File
Hi Aj_Old, sorry about the Double post I tired to remove it but I'm kinda new to this whole web thread business. I have attached a sample excel file with some comments on the objective I'm trying to achieve. Any help or changes you could make to the file would be greatly appreciated. Also i was unable to save attachment as a macro excel sheet so the input page may not function but I've put in a couple samples on the fallowing sheet.Thanks
Attached Files
File Type: xls Sample of Blaircj.xls (57.5 KB, 81 views)
Aj_old's Avatar
Computer Specs
Senior Member with 869 posts.
 
Join Date: Sep 2007
Location: Moldova
Experience: Intermediate
17-Jul-2008, 12:59 PM #5
Look at the Bid sheets!
Is this what you needed?
Attached Files
File Type: xls Copy of Sample of Blaircj.xls (61.5 KB, 81 views)
blaircj's Avatar
Junior Member with 7 posts.
 
Join Date: Jul 2008
Experience: Beginner
17-Jul-2008, 01:12 PM #6
WOW thanks so much! That works perfectly now and I finished the rest of the spreadsheet. Thanks again!
Aj_old's Avatar
Computer Specs
Senior Member with 869 posts.
 
Join Date: Sep 2007
Location: Moldova
Experience: Intermediate
17-Jul-2008, 02:43 PM #7
you are welcome!
Reply

Tags
excel

THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
WELCOME TO TECH SUPPORT GUY! Are you looking for the solution to your computer problem? Join our site today to ask your question -- for free! Our site is run completely by volunteers who want to help you solve your computer problems. See our Welcome Guide to get started.
Thread Tools



Facebook Facebook Twitter Twitter TechGuy.tv TechGuy.tv Mobile TSG Mobile
You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 01:10 AM.
Copyright © 1996 - 2011 TechGuy, Inc. All rights reserved.

Powered by Cermak Technologies, Inc.