Wednesday, July 6, 2016

Another Question Re: Using sumif [Anwsered]

Another Question Re: Using sumif

I have a workbook that contains invoices. In col F - the value of the invoiceIn col I - manually entered the date the invoice was paid. I col K - formula to display to display if the invoice was paid on time [Paid OK], paid late [*** PAID LATE ***] or has not yet been paid [*** LATE ***]. The invoices are to be paid by 04/01/2012. TeamName Value DatePaid Team1 £306.00 01/01/2012 Paid OKTeam2 £238.00 05/01/2012 *** PAID LATE ***Team3 £306.00 *** LATE ***Team4 £778.00 14/12/2011 Paid OKI have an overview workbook that shows Management overview of the state of the invoices. This shows, amongst other things: I am showing only the formula in the ‘Income’ col. Income Rebates Total IncomePaid by Due Date £6,235.00 (£51.00) £6,184.00 =SUMIF('Inv-Calc'!K5:K100,"Paid OK",'Inv-Calc'!F5:F100)Paid Late £714.00 £ - £714.00 =SUMIF(K5:K100,"*** PAID LATE ***",F5:F100)Still To Be Paid £5,958.00 (£51.00) £5,907.00 =SUMIF('Inv-Calc'!K5:K100,"*** LATE ***",'Inv-Calc'!F5:F100)My problem is that the last line (Still To Be Paid) is not correct and should display: Still To Be Paid £5,244.00 (£51.00) £5,193.00The difference between the figures is £714.00 - which just happens to be the correct calculation from ‘Paid Late’. Is this because I am using *** in the search value or something else. Any help would be appreciated. Thanking you for your help in advance.

Keys to the Problem Another Question Re: Using sumif

Yes! You have answered your own question.*** LATE *** will find both that value and *** PAID LATE *** because the asterisks will be the wild cards both sides of LATE.To establish that is the reason, you could select the range of data and then use Find/Replace and replace PAID LATE with PAID_LATE.(Include an underscore so it will not match *** LATE ***)If you include the cells with the formulas and the Option for Find/Replace are Lookin formulas then it should correct the formulas also.

Windows Error Reporting - To Fix Another Question Re: Using sumif

Go to Start button.

Open Control Panel.

Go to Windows Error Reporting.

Click on System and Maintenance, then click Problem Reports and Solutions.

Next, click Change Settings located on the left side panel of the Problem Reports and Solutions window.

Select an option to configure how you want Windows to look for a solution to your problems. You may allow Windows to do it automatically or ask you every time to check if problem occurs.

Next, click the Advanced settings link.

Select Off to turn off Error Reporting.

Another Safe way to Repair the Problem: Another Question Re: Using sumif:

How to Fix Another Question Re: Using sumif with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your system. Open it, and it will scan your computer. The junk files will be shown in the scan result.

2. After the scan is done, you can see the errors and problems which need to be fixed.

3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been removed.