Thursday, February 18, 2016

Troubleshoot:2 worksheets need to combine multiple row amounts of 1 worksheet against a single cell on another worksheet Error

2 worksheets need to combine multiple row amounts of 1 worksheet against a single cell on another worksheet

Good morning, I have 2 worksheets

Sheet 1 has the high level of what the customer paid (single line item showing a total of X number of dollars)
Unique cols are;
A (Customer number
B (Quarter in which they paid)

Col C is the high level payment

Sheet 2 has the line items of what each customer (break out of sheet1)
A (Customer number)
B (Quarter in which they paid)

Col C (with muitiple row entries) - has what the customer paid for each part

What I need to do is add up the total amount from lines items belonging to the customer sheet 2 for customer X then get the percentage discount  (1-(sheet 1 /sheet 2)) by comparing it to the total paid (sheet 1 Col C), then put that discount in all the col
D (sheet2) for each line item that match the Customer number and Quarter on Sheet2

Any suggestions would be greatly appreciated

Solutions to the Problem 2 worksheets need to combine multiple row amounts of 1 worksheet against a single cell on another worksheet

Im D2 on Sheet2, as an array formula, confirmed with Ctrl+Shift+Enter:
 
=1 - INDEX(Sheet1!$C$2:$C$100, MATCH(A2 & B2, Sheet1!$A$2:$A$100 & Sheet1!$B$2:$B$100, 0)) / SUMIFS($C$2:$C$300, $A$2:$A$300, A2, $B$2:$B$300, B2)
 
Adjust the ranges to suit your situation.
Fill down as far as needed.

Using System Restore

  • Click on the Start button on the Taskbar.
  • Type "System Restore" (without quotes) in the Search box and hit Enter or,
  • Click on System Restore (when you see System Restore pop up  in the list of search results).
  • Make sure the "Recommended restore" radio button is checked on the restore utility window.
  • Click on Next and follow the instructions given.

Note: There is the option on the restore utility to select "Choose a different restore point". Unless you have a specific reason to select a different date and time than what Windows recommends, just select the recommended option stated in the steps above. If you choose to select another one, follow these steps:

Click on that desired date and time, and Windows 7 will perform a scan for any affected programs in that restore point.

Once completed, click Next and follow the instructions given.

Once you have selected the restore point, your system will start the restoring process, after which you will have to restart the system.

Recommended Method to Repair the Problem: 2 worksheets need to combine multiple row amounts of 1 worksheet against a single cell on another worksheet:

 

How to Fix 2 worksheets need to combine multiple row amounts of 1 worksheet against a single cell on another worksheet with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your system.  Open it, and it will perform a scan for your system. The errors 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. The Fixing part is finished, the speed of your computer will be much higher than before and the errors have been fixed.


Related: Alphabetizing favorites in Windows XP and IE 6 0 I think ATI Radeon Driver Update FindFirstFile giving error The request is not supported in Windows 7 ati radeon hd 3200 driver Office 2010 on Windows 8 freezes waking from sleep mode ati radeon hd 4650 treiber Problem with Windows Explorer This file does not have a program associated with it for performing this action Creative Drivers Start button right click menu options do not work in Windows 8 1 ati radeon hd 3200 graphics driver update Windows 7 basic background colour is black instead of blue ATI Display Driver Windows Vista and IE8 fails to delete history ati radeon hd 4800 driver Intel Management Engine Interface Version V10.0.28.1006 , 100.89 MBytes,Can i only have the default printer show when printing in IE in Windows 8 realtek drivers windows 7 How to restore Windows 8 1 SkyDrive Back up settings realtek audio driver PC will not run Aero under Windows 7 Professional realtek hd audio drivers Problem with Windows Basic Display Adapter after Windows 8 1 64 bit update realtek driver Start button right click menu options do not work in Windows 8 1 realtek sound driver Windows 8 Backup Recovery Troubles realtek driver Windows wont let me install an unknown publisher realtek pcie gbe family controller driver . You can also use it to backup, restore , uninstall, or reinstall drivers.
Read More: Troubleshooting:Windows explorer error on Windows 7 Ultimate 32bit,Solution to Problem: Conditional Formatting to Show Expiration,How to Fix Error - Internet explorer freezes while accessing websites, works fine while browsing office intranet?,How to Fix Problem - Windows 8.1 Metro Applications failed to start.?,SUMPRODUCT using text qualifiers and multiple criteria,I cannot stop Windows Live Messenger from automatically starting at login,My computer won't recognize the external hard drive.,Can't properly open an application in PC,Blank screen coming out of hibernation

No comments:

Post a Comment