Simple Function for Excell to calculate a Checksum of a string that contain a range of Bytes

I need a function for an excell worksheet that takes the data from a string containing several bytes and calculates the sum of all bytes.


The number of bytes may vary.

The Sum must be in hexadecimal;

The return must be in hexdecimal;

The string contains spaces as shown below:

01 30 00 CA 00 00 02 00 52 4A 5B 29 5D 1F 00 03 25 54 5B EC 02 00 00 00 0A 78 69 10 21 AE 27 04

The sum cannot count either the first byte or the last two Bytes, given the example above:


It will be disregarded from the sum:


What will be sum

30 00 CA 00 00 02 00 52 4A 5B 29 5D 1F 00 03 25 54 5B EC 02 00 00 00 0A 78 69 10 21 AE

The last two bytes of the sum will be disregarded.

27 04

Function Return = 06 27

Aptitudini: Excel, Visual Basic, Procesare date, Arhitectură software, Introducere date

Vezi mai multe: calculator function javascript calculate different window, checksum string data vba, creating function excel calculate cidr, mysql calculate difference string, simple function assignment, simple order form calculate total java netbean, simple javascript form calculate budget, simple function php wordpress, simple function python application, calculate time within therapeutic range inr, add simple function magento, wordpress add simple function, access vba simple function, calculate reduction efficiency cooktop range hood, checksum string java, vb6 simple function, algorithm checksum string java, string contain

Despre angajator:
( 0 recenzii ) Fortaleza, Brazil

ID Proiect: #22841274

Acordat lui:


Hello, I would like to work on your project. I have great experience using excel macros / vba, formulas. I intend to do this task using a short custom vba code, within a macro enabled file, it can be made either as a u Mai multe

%selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD în 1 zi
(121 Recenzii)

10 freelanceri licitează în medie 23$ pentru acest proiect


Hi. I am ready to write your project Write apps on your demand in many languages (Visual Basic, VBA, VBS, .NET, C#, JS, Python, Java, PowerShell) Write database apps including many db formats: MS Access, MS SQL, SQL Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(32 recenzii)

Hello. I've read your project details. I am very familiar to Excel. And I can finish this in 1 hour. Let's discuss details over chat. Thank you.

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(9 recenzii)

Hello!! Am very interested in ur project and I'm an expert in Word/Excel/Excel Marcos/VBA/Visual basic/Data Entry/Data processing and would like to help you with your project. Please ping me for further discussion.

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(4 recenzii)

Hello Sir/Madam, My name is FATIMA and writing is my passion “When I say work, I only mean writing. Everything else is just an odd job”. From my early age, I enjoyed reading novels and stories, as I was growing up it Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(0 recenzii)

I'm expert at excel sheet. And i want to earn somd money.

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(0 recenzii)
%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(0 recenzii)

Hello, I am expart of exel. Like Microsoft exel. So I can complete your project normaly. So you can give me this projects to complete. I am new. Thank you.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(0 recenzii)

Soy experto en Excel Relevant Skills and Experience He realizado varios proyectos en Excel solucionando problemas que de otra manera tomaba horas de trabajo a solo minutos, solo con Excel

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(0 recenzii)

I will do it Relevant Skills and Experience excel

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(0 recenzii)