Ask Experts Questions for FREE Help !
Ask
    Wonder84lalala's Avatar
    Wonder84lalala Posts: 41, Reputation: 1
    Junior Member
    		  
    #1

    Nov 21, 2006, 08:45 AM
    Excel: Entry Counter
    Hi,

    I would like to create an entry / list couter from the cells. For example:
    the entry in (Row 2, Col B) "no room" = 1
    the entry in (Row 3, Col B) "no poc for comms" = 1
    the entry in (Row 4, Col B) "qna not decided" = 1
    the entry in (Row 5, Col B) "n/a" = 0
    The result in (Row 1, Col B) is 3.

    ColumnA Column B
    Issues number (Row 1, Col A) 3 (Row 1, Col B)
    Issue detail (Row 2, Col A) no room (Row 2, Col B)
    Issue detail (Row 3, Col A) no poc for comms (Row 3, Col B)
    Issue detail (Row 4, Col A) qna not decided (Row 4, Col B)
    Issue detail (Row 5, Col A) n/a (Row 5, Col B)

    Great thanks.
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #2

    Nov 21, 2006, 09:04 AM
    So just add a column and assign a 1 or 0 to it based on what's in Col A. Then sum that column.
    Wonder84lalala's Avatar
    Wonder84lalala Posts: 41, Reputation: 1
    Junior Member
    		  
    #3

    Nov 21, 2006, 09:47 AM
    That was the simplest way, but I just wanted to know if there are other ways. Thanks.
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #4

    Nov 21, 2006, 09:55 AM
    Unless the entries in Column A form a pattern. For example if an entry of n/a will be the only zero, you could use a CountIF.
    findinfo's Avatar
    findinfo Posts: 3, Reputation: 1
    New Member
    		  
    #5

    Nov 28, 2006, 09:59 AM
    In the result cell, paste the following:
    =COUNTA(B2:B5)-COUNTIF(B2:B5,"n/a")

    This counts non-blank cells and subtracts the count of the fields with "n/a"
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!

Repair Corrian Counter [ 9 Answers ]

Hi, my wife put a hot pot on the corrian counter top and this caused it to crack about 7 inches. What can I do to repair it? Anything especiallymade for this. I thought to use tub sealer, but don't want to miss up an expensive top. (more than it already is!) Dom

Counter Offer [ 2 Answers ]

Is it possible to cancel a counter offer that has been accepted? If so how should I go about doing it?:confused:

How to remove cambria counter top [ 3 Answers ]

we need to remove a cambria kitchen bar top so we can lower the knee wall and reinstall, the installer won't come back. The knee wall is 2x4 with sheetrock and the Cambria was glued on top with liquid nails Any help would be greatly appreciated

Corian Counter [ 2 Answers ]

What tool would you use to cut Corian? I have a piece from an old kitchen counter that I want to cut into a 20"x20" cutting board. It is about 3/4" thick and the longest cut I have to make is about 24". Thanks

Counter-Strike [ 3 Answers ]

Ok does anyone know how to change your spray logo on Halflife: CounterStrike? If you know how please tell me..

View more questions Search