Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Counting blank cells with multiple criteria (https://www.askmehelpdesk.com/showthread.php?t=103231)

  • Jun 21, 2007, 02:42 PM
    jmaivang
    counting blank cells with multiple criteria
    Hello,
    I need some help with counting blank cells.
    Here's my data:
    Name Feb 07
    Roger x
    Lisa
    Bob x
    Lisa
    Lisa x
    Lisa
    Lisa x
    Bob
    Bob x
    Bob
    Roger x
    Bob x
    Roger

    I need a formula that will count the blank cells in Feb 07 column if the Name column =Roger. Something like if(Name="Roger", countblank(Feb 07)). Please help.

    Thanks
  • Jun 22, 2007, 05:44 AM
    WvR
    All I could come up with si using the dcount and subtracting the count


    Name Feb 07
    Roger x
    Lisa
    Bob x
    Lisa
    Lisa x
    Lisa
    Lisa x
    Bob
    Bob x
    Bob
    Roger x
    Bob x
    Roger


    =COUNTIF(Name,"Roger")-DCOUNTA(data,2,K13:K14)
    The Dcount function refers to a database(including headings), 2 is the second column in the databse, K13 is Name and K14 is Roger

    Hope this helps

  • All times are GMT -7. The time now is 07:20 AM.