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

    Oct 26, 2006, 12:32 PM
    COUNTIF (counting two different rows)
    Ok I have a countif statement that says...

    =COUNTIF(A:A,"A0067")


    A0067 is a type of radio we are using. This spreadsheet list what radios are down for repair.

    This particular radio belongs to Department A so in Colume B it has "Department A" right beside it.

    Now there are some A0067's that belong to Department B. The Countif statement only counts the total amounts of A0067's that are down all together. Is there anyway I can make it Count A0067's for Department A and Department B separate?:confused:

    I was thinking I could...

    =COUNTIF(A:A,B:B,"A0067";"Department A") but that doesn't work.

    Any suggestions?
    mccloudm's Avatar
    mccloudm Posts: 7, Reputation: 1
    New Member
    		  
    #2

    Oct 26, 2006, 03:45 PM
    Maybe I am thinking about this the wrong way. I was thinking,

    =IF(A:A="A0067" B:B="A",TRUE,FALSE)

    But that gives me a syntax error. And I don't think I can make it coun't how many of the statement is true.

    I am at my wits end with this one.

    Answer my own queston... again.

    This is how I did it.

    {=COUNT(IF((A13:A18="A0067")*(J13:J18="A"),P13:P18 ))}

    tada!
    WvR's Avatar
    WvR Posts: 16, Reputation: 3
    New Member
    		  
    #3

    May 18, 2007, 02:24 AM
    you could also do the following

    =IF(B:B="A",COUNTIF(A:A,"A0067"),0) in another cell do the same for B

    or you could reference to either A or B


    good luck
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!

Calorie counting [ 1 Answers ]

This might be a silly question but you won't know unless you ask,too count calories do you add up calories+calories from fat+carbs+sodium... this always puzzled me.Or do you add everything that stores fat from the nutrient fact chart?

34 weeks and counting [ 7 Answers ]

Well the dr said that he wants me to wait till Friday before going into labor. He also wrote a perscription to help make that possible. The babies are 4lbs 4oz and doing great. I have an appointment next week, he said if I make it that long. I am one and a half cm dialated and measuring full term...

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!

Source of income different from state of work and residence [ 1 Answers ]

I was in F1- OPT from feb 1 of 2005 and got employed by a firm in NJ and am working as a IT tech support for a client in Nashville ,TN. I have been living in TN for about an year now. I have been paying the federal tax (15%) and also the NJ state tax till date. From August I have transferred to an...

View more questions Search