Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Please Help with Formula!
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 -- dutch4fire23 ------------------------------------------------------------------------ dutch4fire23's Profile: http://www.excelforum.com/member.php...o&userid=36900 View this thread: http://www.excelforum.com/showthread...hreadid=566146 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |