Ask Experts Questions for FREE Help !
Ask
    jmaivang's Avatar
    jmaivang Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Jun 21, 2007, 02:42 PM
    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
    WvR's Avatar
    WvR Posts: 16, Reputation: 3
    New Member
    		  
    #2

    Jun 22, 2007, 05:44 AM
    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
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Clicking differnet cells and it selecting all cells [ 2 Answers ]

Just wondered if anyone knew what I did to get ms excel to select all cells from A1 to what ever cell I clicked on. Thought it was sticky keys but it was turned off. Clicked left mouse button and it moved cells then when I clicked other cells it started using that as a new ref point and selecting...

Counting Cells If several criteria are true [ 1 Answers ]

Another question. I'd like to count the number of cells in column C that have "incorrect" in them, if the corresponding cells in column A have "people" in it, and column B has "intact" in it. So if A = people and B = intact, count all C that = incorrect. Thanks!

Excel: 2 criteria - 1 answer [ 9 Answers ]

GMorning Ladies/Gentlemen! Here's a small question: Is it possible to have two criteria which are filled in by a user, and in a third box an answer appears? I have put an example attached in zip format. Many thanks, Srecak

View more questions Search