How Can You Fix - Embed a LEFT() function inside a COUNTIFS() formula??

Embed a LEFT() function inside a COUNTIFS() formula?

I have a workbook with the following formula:
 
=COUNTIFS(BusUnit,B$1,Division,B$2,MachineType,"L",LeftCLIN,"0401")+
COUNTIFS(BusUnit,B$1,Division,B$2,MachineType,"L",LeftCLIN,"0460")+
COUNTIFS(BusUnit,B$1,Division,B$2,MachineType,"L",LeftCLIN,"0438")+
COUNTIFS(BusUnit,B$1,Division,B$2,MachineType,"",LeftCLIN,"0438")
 
This formula is used on multiple worksheets with a variable parameter in
B$2 that allows me to do calcuations for Divisions with ID numbers like 4.2.1, 4.2.1.1, 4.2.3 etc.
 
Now I need to create an aggregate sheet that totals the values for ALL the Divisions that are in the "4.2" part of the organization.  I THOUGHT I would use the following formula, but Excel keeps giving me an error:
 
=COUNTIFS(BusUnit,B$1,LEFT(Division,4),"4.2.",MachineType,"L",LeftCLIN,"0401")+
COUNTIFS(BusUnit,B$1,LEFT(Division,4),"4.2.",MachineType,"L",LeftCLIN,"0460")+
COUNTIFS(BusUnit,B$1,LEFT(Division,4),"4.2.",MachineType,"L",LeftCLIN,"0438")+
COUNTIFS(BusUnit,B$1,LEFT(Division,4),"4.2.",MachineType,"",LeftCLIN,"0438")
 
The error I get is:
 
The formula you typed contains an error.
• For information about fixing common formula problems, click Help.
• To get assistance in entering a function, click Function Wizard (Formulas tab, Function Library group).
• If you are not trying to enter a formula, avoid using an equal sign (=) or minus sign (-), or precede it with a single quotation mark (').
 
Can anyone help me?  Do I have a syntax problem that I am not seeing?  I've tried to dumb down the formula and just use an embedded LEFT() within a COUNT() function and I can't do that, either.  Is this simply not supported?
 
As always, thank you for your help.

Keys to the Problem Embed a LEFT() function inside a COUNTIFS() formula?

Download Error Fixer (Free)

Change your formula to (Put * behind 4.2.  and don't use left in Division
 
=COUNTIFS(BusUnit,B$1,Division,"4.2.*",MachineType,"L",LeftCLIN,"0401")+
COUNTIFS(BusUnit,B$1,Division,"4.2.*",MachineType,"L",LeftCLIN,"0460")+
COUNTIFS(BusUnit,B$1,Division,"4.2.*",MachineType,"L",LeftCLIN,"0438")+
COUNTIFS(BusUnit,B$1,Division,"4.2.*",MachineType,"",LeftCLIN,"0438")

Manually editing the Windows registry

Caution: Unless you an advanced PC user, please do not edit the Windows registry manually.

Because of this risk, we highly recommend using a trusted registry cleaner such as SmartPCFixer Using a registry cleaner automates the process of finding invalid registry entries, missing file references (like the one causing your MACHINE_CHECK_EXCEPTION error), and broken links within the registry. A backup is automatically created before each scan, with the ability to undo any changes in a single click, protecting you against the possibility of PC damage. The best part is that repairing registry errors can also dramatically improve system speed and performance.

• Click the Start button.
• Type "command" in the search box... DO NOT hit ENTER yet!
• While holding CTRL-Shift on your keyboard, hit ENTER.
• You will be prompted with a permission dialog box.
• Click Yes.
• A black box will open with a blinking cursor.
• Type "regedit" and hit ENTER.
• In the Registry Editor, select the Error 0x9C-related key (eg. Windows Operating System) you want to back up.
• From the File menu, choose Export.
• In the Save In list, select the folder where you want to save the Windows Operating System backup key.
• In the File Name box, type a name for your backup file, such as "Windows Operating System Backup".
• In the Export Range box, be sure that "Selected branch" is selected.
• Click Save.
• The file is then saved with a .reg file extension.
• You now have a backup of your MACHINE_CHECK_EXCEPTION-related registry entry.

The next steps in manually editing your registry will not be discussed in this article due to the high risk of damaging your system. If you would like to learn more about manual registry editing, please see the links below.

Recommended Method to Repair the Problem: Embed a LEFT() function inside a COUNTIFS() formula?:

How to Fix Embed a LEFT() function inside a COUNTIFS() formula? 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 done, you can see the errors and problems need to be fixed. Click Fix All.

3. When the Fixing part is done, your computer has been speeded up and the errors have been removed

Related: How to Fix 0x7f Bsod Windows Xp Error?,Troubleshoot: Error code 0xf4 Mrxsmb20 Error,Error Message Blue Screen 0x00000020 Fixer,How to Fix Error Foutcode 0x663?,Troubleshooter of Error: Job 0x80072efd Received For Assignment,How To Resolve Missing frgplugs.dll Problem,Solution to jsurl.dll Missing Error,How to Fix libdlltgeometryres.dll Not Found Error,Corrupted Ltwvc13n.dll File - How to Fix,pholder.dll Missing Error Fixer,Does windows have a program to make a photo from a video if so what and where is it?,does windows 7 word pad have a spell checker?,double horizontal lines,Do many desk top icons slow a computer,Does a messy desktop slow down your computer?