How do I create subtotals on an excel spreadsheet using subtraction?

I have a spreadsheet that is about 18000+ lines. I have sorted the spreadsheet so that it is by part number. Along with the part number I have the quantities all lined up. I need the difference of the quantities of each part to give me my accurate totals. I am trying to use the Subtotals command to do this process for me seeing as how I have many different parts. The only problem is that under the Subtotals command, it only gives you the ability to use certain formulas and, guess what, subtraction is not one of them. I am not going to crunch these numbers individually (this is why we have computers now) because it would take me probably close to a month to do so without losing my mind. I can't sit here and put individual formulas in 8000+ cells. Please, if anyone can help me here it would make my life a heck of a lot easier. I was recently promoted to the inventory control supervisor position at my job and I am trying to fix almost a decade of mistakes. Not doing inventory in almost ten years is the first one that I need to rectify. Thanks a million. I am using excel 2003. The quantities are also stacked on top of eachother not horizontally so the formula would be different. It could start as C3 - C4 and then jump down the list to one of the lower items and be C18000 - C18001. Here is an example: 346ATF DODGE 1QT1 346ATF DODGE 1QT-3 The first line is the amount and the second line is the amount used. I need to subtract the -3 from the 1. If someone would be willing to show an email, I could email a portion of it, or all of it to the interested party willing to help. Thanks

Asked By: Confuzzled - 11/6/2009
Best Answer - Chosen by Asker
can you provide a small sample of what you need? edit- i sent you a message. C3 = 1 C4 = -3 so =C3-C4 will give you 4 is that right? whst if C18000 = 7 and C18001 = -2 =c18000-c18001 will give you 9 did you want to add the 9 and the 4 and you get 13? in excel 2003 you can use a sumproduct() for this
Answered By: expletive_xom - 11/6/2009
Additional Answers (1)
Oh my goodness no inventory in 10 years! We do ours annually and cycle count everyday M-F...besides that... More
Answered By: Rachel - 11/6/2009
Sponsored results
Over 483 Local Jobs Now Hiring In Your Area. $18-$87/Hr - Apply Today!
Click. Search. Apply. Free!
Jobs hiring near your local area. Part-time, Full-time, Work at home.
Sobre 287 Trabajos en tu area. $15-87/hora - Aplica Ahora.

Other Career Questions

What is your current job? Why did you choose this job? What do you enjoy about your job? What do you dislike about your job? What would be your perfect job? Would you rather have this j...
3 answers - Asked By: drop pants not bombs!.♥ - 3/2/2010
Where are the jobs? Is productivity and globalization creating a permanent “recession” of jobs? My main issue is I am doing a paper for school and have no idea where to begin. I was hoping suggestions...
4 answers - Asked By: bayebd24【ツ】 - 11/21/2007
Hi ok im 19 and about to start college to do an acess course into a university. Ive been browsing through all the courses and im tottaly stuck! I thought politics but im scared ill end up with some r...
1 answers - Asked By: roseparkerly - 1/26/2009

Content is not owned or controlled by Monster. Any content concerns should be addressed with Yahoo!
Yahoo! Does not evaluate or guarantee the accuracy of any Yahoo! Answers content. Yahoo! Disclaimer.

Popular Articles

Best-Paying Work-from-Home Jobs Article Rating
It’s easier than ever to work from home. Of course, not every job is a mobile job, and some companies aren’t interested in having their employees work from home.
2013 Marketing Jobs Outlook Article Rating
The US may be facing another year of anemic hiring overall, but that won't be the case in the high-orbit world of multichannel, digital media marketing.
For Employers: Post Jobs | Search Resumes | Advertise
About Monster | Work for Monster | Advertise with Us | AdChoices | Partner with Us | Investor Relations | Social Media
Terms of Use | Privacy Center | Accessibility Center | Help | Security | Contact Us | Sitemap | Mobile
©2014 Monster - All Rights Reserved U.S. Patents No. 5,832,497; 7,599,930 B1; 7,827,125 and 7,836,060 MWW - Looking for Monster Cable? - V: 2014.1.40.24-306