sumifs formula returns error

[kronikjb]

Book1.xlsx

formula =SUM(SUMIFS(G$4:G$32600;$C$4:$C$32600;{"W","L"};G$5:G$32601;"PICK";L$3:L$32599;"<="&2/24)) returns an error.
i would like to count how many numbers are under conditions "w or l" and "pick" and are smaller than 2/24.

[windy58]

Can you use the "," separator.

When I change the separator from ";" to "," I get a result of 43.63

Windy

[daddylonglegs]

Whether you need comma separators or semi-colons is determined by your regional settings, so I'm assuming semi-colons are correct for Kronikjb's region, but it worked for me with commas as Windy says - what error did you get?

[kronikjb]

"the formula you typed contains an error"

[kronikjb]

are there any other regional changes beside , to ;?

[oeldere]

You get better help on your topic if you add to whom you are replying.

Please Login or Register  to view this content.

[kronikjb]

Whether you need comma separators or semi-colons is determined by your regional settings, so I'm assuming semi-colons are correct for Kronikjb's region, but it worked for me with commas as Windy says - what error did you get?

"the formula contains an error" the one who wrote this formula has different regional settings than me, he uses , insted of ;. are there any other regional changes

[oeldere]

Not that I am aware of.

1) In that case change, as already offered, the , in ; in the offered solution.

But having said that, I don't think that is the solution, since Excel automatic changes the formula (including the ; or , in the formula).

2) Or did you get the formula on the forum and pasted it in your file?

3) In that case you can use the solution under 1)