Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2012
    Posts
    3

    Unanswered: Multiple criteria multiple columns

    I am attemping to create a database that will keep track of landing and arriving times of different services. I need to be able to count the data in column G only if there is an input in a cell and only if it meet the criteria matching in column B.

    Basically, count G6 only if there is an input value(time) and if B6 is "AIR CARRIER". The closest I have come to the correct input is, =SUMPRODUCT(($G$6:$G$132>=0)*($B$6:$B$132="AIR CARRIER")) This counts the cells in G if B is "AIR CARRIER", but does not take into account if the cell is blank or filled.

    Please Help!

  2. #2
    Join Date
    Jun 2012
    Location
    Greyton, South Africa
    Posts
    19
    Which field may be blank? I think the formula you posted does exactly what you have described.

  3. #3
    Join Date
    Jun 2012
    Posts
    3
    Column B is a drop list that has AIR CARRIER as a selection, column G has time input ranging from 0000-2359, but not all the cells in column G have time inputs in them.

  4. #4
    Join Date
    Jun 2012
    Posts
    3
    here is the formula that worked.

    =SUMPRODUCT(($B$6:$B$132=$K12)*(ISNUMBER(G$6:G$132 )))

Posting Permissions

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