Coding⏱️ 3 min read📅 2026-06-11

How to Fix: Adding Range of Numbers that Had Been Converted Using HEX2DEC()? (Receiving Error)

Excel error with HEX2DEC() function and large dataset

Quick Answer: Use the HEX2DEC() function in a single formula by separating the numbers with commas, e.g. =SUM(HEX2DEC(A1:A2)) becomes =SUM(HEX2DEC(04cf,04fb))

📋 Table of Contents

  1. 💡 Why You Are Getting This Error
  2. 🛠️ Step-by-Step Verified Fixes
  3. ✨ Wrapping Up

The error 'Adding Range of Numbers that Had Been Converted Using HEX2DEC()? (Receiving Error)' occurs when you try to add hexadecimal numbers converted using the HEX2DEC() function in Excel. This issue affects users who are trying to perform calculations with hexadecimal values, but may not be familiar with how to handle them correctly.

This error can be frustrating because it prevents users from completing their tasks and achieving their goals. However, by following the steps outlined in this guide, you will be able to resolve the issue and perform your desired calculation.

💡 Why You Are Getting This Error

  • The primary reason for this error is that hexadecimal numbers cannot be directly added using the HEX2DEC() function. The HEX2DEC() function converts a hexadecimal number to decimal, but it does not allow you to add multiple hexadecimal values together.
  • An alternative cause of this error may be that the range of cells being summed includes cells with different data types or formatting.

🛠️ Step-by-Step Verified Fixes

Using Separate Decimal Columns

  1. Step 1: Select cell A1 and enter the formula =HEX2DEC(A1) to convert the hexadecimal number to decimal.
  2. Step 2: Repeat this step for cell A2, entering =HEX2DEC(A2).
  3. Step 3: Create a new column (e.g. column C) next to cells A1 and A2, and enter the formulas =A1+C1 and =A2+C2 respectively. This will allow you to add the two decimal values together without having to use the HEX2DEC() function.
  4. Step 4: Copy the formula for cell C1 down to all other cells in column C, and then copy the formula for cell C2 down to all other cells in column C as well.

Using Array Formulas

  1. Step 1: Select cell B1 and enter the formula =SUM(IFHEX2DEC(A:A)=A1,A1,0).
  2. Step 2: This formula will sum up all values in column A that match the value in cell A1.
  3. Step 3: Repeat this step for cell B2, entering =SUM(IFHEX2DEC(A:A)=A2,A2,0).
  4. Step 4: Copy the formula down to other cells in row 2 as needed.

✨ Wrapping Up

By following either method 1 or method 2, you should be able to resolve the error and add your hexadecimal numbers together correctly. Remember to always verify that your formulas are correct and make adjustments as necessary.

Did this fix your problem?

If not, try searching for specific error codes.

🔍 Search Error Database

❓ Frequently Asked Questions

🛠️ Related Fixes

How to Fix: Stuck in tutorial hell after 4 years: How do I b

Fix Stuck in tutorial hell after 4 years: How do I bui. Practice build

How to Fix: Trying to sync mutliple audio tracks to a movie

Fix Trying to sync mutliple audio tracks to a movie bu. Consider using

How to Fix: Failed to merge latest branches from upstream re

Fix Failed to merge latest branches from upstream repo. Try running 'g