Copy formula down in between subtotaled lines - part2
column E = category
Subtotals are at each change in category
Need to figure out sales $ (column U) for each line within the subtotal group
Percents are preloaded (column V)
I know that for category 1, total sales are $10.
There are 3 skus and I know that they are 2%, 5%, and 3% of the total $10 respectively.
The formula to figure out each line's sales $ is not the question, it's how to copy this down 5k lines.
Solutions to the Problem Copy formula down in between subtotaled lines - part2
1. Assume data is in range A1:H11. Headings are in row 1
You want the formula to appear in G2:G5 and G7:G10. So on for 6000 lines
Select range G2:G11 and press Ctrl+G > Special > Blanks. This will select G2:G5 and G7:G10
By default cell G2 will be active and in that enter the following formula
In all blank cells in column G, the correct $ amount should appear.
Do let me know how this works for you?
Because of this Copy formula down in between subtotaled lines - part2 error, Windows can fail in starting some processes and the system's performance can significantly slow down. In some cases, Windows has problems starting up and the system can freeze.
Lastly, this error Copy formula down in between subtotaled lines - part2 can even result in the Blue screen of death error message, just like other critical Windows errors. If any of the above problems and symptoms occur in your PC, then you should immediately seek to resolve this problem.
In order to resolve Copy formula down in between subtotaled lines - part2 error or repair the corrupted and damaged Windows files, you will need a Copy formula down in between subtotaled lines - part2 error repair tool. There is more than one method of treating this kind of error code, and here is how you can manually do it:
- Start the computer and log in as administrator
- Go to the start button and select All Programs. Go to Accessories, System Tools, and then System Restore
- Click on System Restore and in a new window, select the 'Restore my computer to an earlier time's option and click Next
- On the new confirmation window that appears, click Next
- Restart your computer after the restoration has been completed
Another Safe way to Repair the Problem: Copy formula down in between subtotaled lines - part2:
How to Fix Copy formula down in between subtotaled lines - part2 with SmartPCFixer?
1. Download SmartPCFixer . Install it on your system. Click Scan, and it will perform a scan for your computer. The junk files will be shown in the list.
2. After the scan is finished, you can see the errors and problems which need to be fixed.
3. When the Fixing part is finished, your computer has been speeded up and the errors have been removed
Related: AVG Technologies ScriptHelperApi Class Add-on,After Running Sysem Restore My PC Running Windows 7 Home Premium Fails To Restart And On Manually Restarting Tells Me The Restore Has Failed Error Code Ox80070005,Access Data Base Engine DLL,After Changing Drive Letters W/ Disk Management In Windows 7 I Can No Longer View My Drives In "Computer",Automatically Deletes Mail When Exiting The Program,Not Able To Access Internet Explorer 8 Correctly.,Backup Error,Sign In Prob. With Games For Windows-live In Dirt 2,I'm Having Trouble Storing My Iphone Contacts In Windows Contacts,Dispositivo Microsoft Notebook Reciever V2.0 No Se Reconoce Dispositivo USB Error 43
Read More: Fast Solution to Error: my system start hanging after a while and all the working of computer gets affected,Solution to Problem: Adobe Reader 9.3 error runtime has encountered a problem.,[Solution] IE10 don't like pop ups, IE10 has pop-tabs Arrg.,Fast Solution to Error: Bing Bar and Silverlight fouled up and why is not activation code no longer good?,Solution to Problem: I cant install \"Microsoft.NET framework 1l1 Service pack 1 security update for XP, Have been receiving error message every time I try to install since 10\/21,Agentctl.dll registration on windows 8 64-bit,Full Cross Reference,How do I stop ads from flickering on Internet Explorer?,black changes to 87% when converting to spot color,Extra Zero's on Time in Excel.