Results 1 to 4 of 4

countifs function

Threaded View

  1. #1
    Registered User
    Join Date
    01-31-2007
    Posts
    47

    countifs function

    Hi all - I have a COUNTIFS function that I can't seem to get to work. Basically it is looking for 2 criteria (the count from certain division and certain products) between a date range (first and last day of the month). All cells are referenced and formula as follows:

    =COUNTIFS($I$3:$I$22,"=$A$5",$J$3:$J$22,"<="&B4,$J$3:$J$22,">="&B3,$K$3:$K$22,OR("=$A$12","=$a$13"))

    A5=division
    B4=end date
    B3=start date
    A12= product type1 (A)
    A13= product type2 (AA)

    I've attached a 07 workbook below (as it's a countifs) and don't know if this could also be done via a sumproduct. In case it affects things at all, I'm referencing cells from other worksheets...

    Any help is greatly appreciated as it will save me banging my head on my desk (again).

    doowop
    Attached Files Attached Files

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