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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks