Results 1 to 8 of 8

sumifs formula returns error

Threaded View

  1. #1
    Registered User
    Join Date
    01-30-2015
    Location
    slovenia
    MS-Off Ver
    2010
    Posts
    35

    sumifs formula returns error

    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] SUMIFS returns a #Value error when the external spreadsheet is closed.
    By adil.master in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-27-2017, 12:37 PM
  2. Sumifs formula returns ZERO
    By Xx7 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-10-2013, 02:05 PM
  3. Sumifs Formula Error
    By Hudson in forum Excel General
    Replies: 3
    Last Post: 02-17-2012, 03:16 PM
  4. SUMIFS returns VALUE!
    By mogdog1981 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-03-2011, 04:38 AM
  5. Sumifs error in formula
    By Grimzby in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 02-29-2008, 06:39 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1