+ Reply to Thread
Results 1 to 3 of 3

countif or sumproduct?

  1. #1
    Registered User
    Join Date
    03-09-2007
    Posts
    51

    Question countif or sumproduct?

    Using the following formula I can count the number of invoices which contain the data in cell 'M1' which happens to be an 'x' in this case.

    =COUNTIF(F16:F1204,M1)

    However, i need to add another criteria - i need to be able to count the number of invoices within the data range F16:F1204 which contain the same data as in cell M1 but also only to count the number of invoices within this range which DO NOT contain the phrase "Paid Account" in the corresponding cells of the data range J16:J1204

    I'm not sure whether I can include multiple criteria in a countif function or whether I have to use a SUMPRODUCT formula, and if so, how??

    Any help would be much appreciated.

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    Try

    =SUMPRODUCT(--(F16:F1204=M1),--(J16:J1204<>"Paid Account"))
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    03-09-2007
    Posts
    51

    Smile

    Excellent! That works fine thanks, I can now amend the formula for the other similar things I need.

+ 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