Can someone explain to me why this SUMIF isn't giving me the sum of D2+D3?
Conversation
Notices
-
Embed this notice
Børge (forteller@tutoteket.no)'s status on Saturday, 11-Jan-2025 09:42:44 JST Børge
-
Embed this notice
Børge (forteller@tutoteket.no)'s status on Saturday, 11-Jan-2025 09:57:10 JST Børge
@elmau Huh, that's crazy! Thanks for checking! For me it just says Err:508
Can you receive via Warp?
1-whimsical-printer-infancy-showgirlIf not, here's another way: https://transfer.zip/#JwkP8-e89tRkSKdrNpfMTDnwkHyCcA-7OWprnU0ZncQ,f35ffd69-7cea-406a-9c47-773ebf4b1628,R
-
Embed this notice
El Mau :archlinux: :python: (elmau@mstdn.mx)'s status on Saturday, 11-Jan-2025 09:57:11 JST El Mau :archlinux: :python:
@forteller work fine in my system. Please, attach your file.
Version: 24.8.4.2 (X86_64) / LibreOffice Community
Build ID: 480(Build:2)
CPU threads: 16; OS: Linux 6.12; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
24.8.4-2
Calc: threadedIn conversation permalink Attachments
-
Embed this notice
Børge (forteller@tutoteket.no)'s status on Saturday, 11-Jan-2025 10:17:00 JST Børge
@elmau Oh wow! So I'm not just totally incompetent, then, that's good to know :P
I see I'm on an older version than you, 24.2.7.2, so I guess I'll have to try and upgrade and see if that helps.
Thanks!
In conversation permalink -
Embed this notice
El Mau :archlinux: :python: (elmau@mstdn.mx)'s status on Saturday, 11-Jan-2025 10:17:01 JST El Mau :archlinux: :python:
@forteller Your file work fine in my system.
In conversation permalink Attachments
-
Embed this notice
Børge (forteller@tutoteket.no)'s status on Saturday, 11-Jan-2025 10:20:57 JST Børge
@elmau Nope, I updated and is now on
Version: 24.8.4.2 (X86_64) / LibreOffice Community
Build ID: bb3cfa12c7b1bf994ecc5649a80400d06cd71002
CPU threads: 12; OS: Linux 6.11; UI render: default; VCL: gtk3
Locale: en-US (en_US.utf8); UI: en-US
Flatpak
Calc: threadedand I still get the same error: Err:508
In conversation permalink -
Embed this notice
Børge (forteller@tutoteket.no)'s status on Saturday, 11-Jan-2025 10:24:45 JST Børge
@elmau WTF! Now I tried to just remove the opening and closing paranthesis (since the error message was about those in some way) and adding them back in, and then it works! No idea why, but yeah…
Thanks again! :)
In conversation permalink
-
Embed this notice