There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
 
Tag Cloud
acer black screen blue screen of death boot bsod computer connection crash css dell display driver drivers email error explorer firefox firefox 3 game hard drive internet internet explorer itunes laptop lcd linux malware monitor network networking outlook outlook 2003 outlook express password printer problem problems router security slow software sound trojan usb video virus vista windows windows xp wireless
Business Applications
Search
Search in:
 
Advanced Search
Tech Support Guy Forums > Software & Hardware > Business Applications >
Solved: Excel 2007 Seeking subtotals HELP


HELLO AND WELCOME! Before you can post your question, you'll have to register -- it's completely free! Click here to join today! We highly recommend that you print a copy of our Guide for New Members. Enjoy!

Closed Thread
 
Thread Tools
blaircj's Avatar
Junior Member with 7 posts.
 
Join Date: Jul 2008
Experience: Beginner
17-Jul-2008, 09: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 624 posts.
 
Join Date: Sep 2007
Location: Moldova
Experience: Intermediate
17-Jul-2008, 10:16 AM #2
Hi blaircj, you have double posted! Delete one of two threads!
Aj_old's Avatar
Computer Specs
Senior Member with 624 posts.
 
Join Date: Sep 2007
Location: Moldova
Experience: Intermediate
17-Jul-2008, 10: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, 11:00 AM #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, 8 views)
Aj_old's Avatar
Computer Specs
Senior Member with 624 posts.
 
Join Date: Sep 2007
Location: Moldova
Experience: Intermediate
17-Jul-2008, 11:59 AM #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, 6 views)
blaircj's Avatar
Junior Member with 7 posts.
 
Join Date: Jul 2008
Experience: Beginner
17-Jul-2008, 12: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 624 posts.
 
Join Date: Sep 2007
Location: Moldova
Experience: Intermediate
17-Jul-2008, 01:43 PM #7
you are welcome!
Closed Thread

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.


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 help people like you solve computer problems. See our Welcome Guide to get started.



Thread Tools


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 06:07 PM.
Copyright © 1996 - 2008 TechGuy, Inc. All rights reserved.
Powered by vBulletin, Copyright © 2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Powered by Cermak Technologies, Inc.