Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-28-2006, 12:41 PM
dutch4fire23 dutch4fire23 is offline
Novice
Please help with Sum formula to add totals by State! asap
 
Join Date: Jul 2006
Posts: 2
dutch4fire23
Default Please help with Sum formula to add totals by State! asap

Hello, I am a new user and I am having great difficulty in figuring out something. I have a dataset in Excel with first names, last names, states, cd sales total cost by state... and I am I started a new worksheet cales total sales y state. Now, in this new sheet I want have the states copied over and in the B2 cell I want to write a formula that will enable me to have the total cost from O2:O112 cells ("Total Sales") to be sumed up by each state with absolute references. How would I do this? Example I am currently using =SUMIF(Demographics!F2:F112, "AK", Demographics!O2:O112) which is giving me the correct total sales for AK, but I want to copy this formula using absolute references and have the states change while keeping the fields O2:O112 the same. I just don't want to enter in each state which is what I was starting to do, but It will take a while =SUMIF(Demographics!F2:F112, "IA", Demographics!O2:O112)



as an example here is Totals by State! worksheet:

AK $324.50 <---- Total from Demographics! for AK
IA $428.68

Using the above formula to calculate the totals for each state. I want to copy the formula from the B2 for AK cell and paste it so I do not have to go in and change the formula for each one

Here is the Demographics! Worksheet as an example:

States: Total Sales for the year
AK <--F2 $100 <--- O2
AK $100
AK $100
Ak $100
IA $150
IA $150
IA $100


Do I need a different formula all together or just change F2:F112 to $F$2:$F$112 and O2:O112 to $O$2:$O$112, but how to I have Excel change the states without me having to type in each state in each new state row.

Any Help id greatly appreciated, Thank you

Andy
Edit/Delete Message
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Please help with Sum formula to add totals by State! asap Excel Formula Help Shahzad Excel 1 12-07-2008 04:13 AM
Resetting to Default State not working carlgrossman Word 0 08-02-2008 01:31 AM
formula in excell curlymal Excel 2 02-09-2007 11:34 AM
Mailmerge Formula mridley Mail Merge 0 07-27-2006 03:16 AM
Please help with Sum formula to add totals by State! asap Stuck on this formula!!!! CADmanJP Excel 2 03-10-2006 02:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:52 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft