LinkBack URL
About LinkBacks
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.
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.
Last edited by kronikjb; 02-21-2015 at 08:18 AM.
Can you use the "," separator.
When I change the separator from ";" to "," I get a result of 43.63
Windy
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?
Audere est facere
"the formula you typed contains an error"
are there any other regional changes beside , to ;?
You get better help on your topic if you add to whom you are replying.
Please Login or Register to view this content.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
"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 changesOriginally Posted by daddylonglegs
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)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks