Computer Error Fixer: 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 invoice
In 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 OK
Team2                   £238.00
05/01/2012           *** PAID LATE ***
Team3                   £306.00
                                *** LATE ***
Team4                   £778.00
14/12/2011           Paid OK
I 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 Income
Paid 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.00
The 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

Download SmartPCFixer for Free Now

Is this because I am using *** in the search value or something else.

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.