+ Reply to Thread
Results 1 to 5 of 5

Countifs alternative for Excel 2003

  1. #1
    Registered User
    Join Date
    05-17-2012
    Location
    Sadlenebtitri
    MS-Off Ver
    Excel 2010
    Posts
    17

    Countifs alternative for Excel 2003

    This is the preety simple formula I am using with Excel 2010
    =COUNTIFS(H1:H20,D80,L1:L20,"<>")
    But it does not work with excel 2003
    On the second criteria range (L1:L20) I want to count cells with any value (it could be anything except for blank cell)
    Can you please provide an excel 2003 compatible forumal ?
    I think its sumproduct, but not sure how to use it.
    Thanks

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Countifs alternative for Excel 2003

    Try this one.

    =sumproduct((H1:H20=D80)*(L1:L20="<>"))

  3. #3
    Registered User
    Join Date
    05-17-2012
    Location
    Sadlenebtitri
    MS-Off Ver
    Excel 2010
    Posts
    17

    Re: Countifs alternative for Excel 2003

    Nope, it does not return the same answer as countifs formula.

  4. #4
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Countifs alternative for Excel 2003

    You'll need a subtle change of syntax with SUMPRODUCT, i.e.

    =SUMPRODUCT((H1:H20=D80)*(L1:L20<>""))
    Audere est facere

  5. #5
    Registered User
    Join Date
    05-17-2012
    Location
    Sadlenebtitri
    MS-Off Ver
    Excel 2010
    Posts
    17

    Re: Countifs alternative for Excel 2003

    This worked, thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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