My SUMIF formula ads numbers 15 places after the coma.

Hola,
keine Ahnung was Summewenn() damit zu tun hat.
Google nach Gleitkommaproblematik. Du musst deine Subtraktion runden.
Gruß,

Hi Daniel, thank you for reaching out!

My name is Rolyn, an Independent Advisor and a Microsoft Excel User like you. I would love to help you out with your concern.

There's a thing in excel where it only treats the first 15 digits as significant and anything after the 15th digit, excel would turn it to zero. If the cells are formatted as a text, like in your case, once you apply a mathematical equation like sumif, it will
turn those digits into number format, hence the incorrect returned values.

Perhaps you can try using this formula on your Column C and see if it works: =SUMPRODUCT(--($A:$A=$A2),$B:$B)

This article gives a pretty good explanation about this:
https://wmfexcel.com/2015/01/24/15-significant-...

(Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised
on the site before you decide to download and install it.)

Let me know if that worked out well for you. Feel free to ask me if you need further assistance.

Thanks,

Rolyn

Hallo Norbert ich bin ein unabhängiger Office Experte, das geht so nicht mit 3D Formeln aber hier ist ein Workaround:

https://exceljet.net/formula/3d-sumif-for-multi...

good Morning,
Thank you for your response.
When I move the mouse pointer over the icon, the following is displayed:
OndeDrive-Personal
Current!
If I double click it, my OneDrive folder will be shown on the PC!
When I right-click on Ads Online, it shows me my folders in the OneDrive cloud. It also shows that I am logged in!
So I'm signed in! In my view, it can't be because of that!

Many thanks for your help!

Best regards

Hallo,



dann musst du den Summen- und Kriterienbereich absolut setzen und das Kriterium relativ:



Range("B3:AZ3").Formula = "=SUMIF($E$5:$E$100,B1,$F$5:$F$100)"

Außerdem reicht bei deinen Voraussetzungen SUMIF, denn du hast nur einen Kriterienbereich.



Mit freundlichen Grüßen

Claus