Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Count problems[Excel 97]
Hi there, I did a search on the forum to find an answer to my question but didn't find anything. Here is my prob : Lets say I got this page- ___a___b_____c__d__ 1 Name Type Job bla 2 Name Type Job bla 3 Name Type Job bla 4 Name Type Job bla 5 Name Type Job bob I want a Cell to write how many row I got( 5 in this exemple) and only count the cells with bla in the D column(4 in this exemple). Sorry if I'm not really clear but if you can help me feel free to answer :) thx, Tulkas. -- Tulkas ------------------------------------------------------------------------ Tulkas's Profile: http://www.excelforum.com/member.php...o&userid=24386 View this thread: http://www.excelforum.com/showthread...hreadid=379763 |
#2
|
|||
|
|||
The COUNTA(D1:D100) function will count all non-blank cells in the range D1:D100. The COUNTIF(D1:D100,"bla") will count how many times the text "bla" occurs in the range D1:D100. That should work for you unless I missed something. -- MrShorty ------------------------------------------------------------------------ MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181 View this thread: http://www.excelforum.com/showthread...hreadid=379763 |
#3
|
|||
|
|||
It looks like =countif() would work for you:
=countif(d1:d10,"bla") Debra Dalgleish has lots of info about counting cells at: http://www.contextures.com/xlFunctions04.html Tulkas wrote: Hi there, I did a search on the forum to find an answer to my question but didn't find anything. Here is my prob : Lets say I got this page- ___a___b_____c__d__ 1 Name Type Job bla 2 Name Type Job bla 3 Name Type Job bla 4 Name Type Job bla 5 Name Type Job bob I want a Cell to write how many row I got( 5 in this exemple) and only count the cells with bla in the D column(4 in this exemple). Sorry if I'm not really clear but if you can help me feel free to answer :) thx, Tulkas. -- Tulkas ------------------------------------------------------------------------ Tulkas's Profile: http://www.excelforum.com/member.php...o&userid=24386 View this thread: http://www.excelforum.com/showthread...hreadid=379763 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
Count number to reach a cumulative value | Excel Worksheet Functions |