count number of "D"

  • Thread starter Thread starter jayender.vs
  • Start date Start date
J

jayender.vs

Hi dude,
I am new to excel .. here is my requirements.

Code:
--------------------

449 78 d
449 69 m d
458 260 m
469 28 m
472 39 m
479 51 d
484 59 m d
--------------------

i need to count number of "d" present in the 4 th column and number of
m present in the 3 column.. its a very big table and i need to
calculate programically.
how to do it?

thanks in advance !!
 
R.VENKATARAMAN said:
=COUNTIF(A1:A7,"*d")

assuming these entries are in a1 to a7
Click to expand...

thanks VENKATARAMAN,
as i said , am new to excel.. so where should i need to give the code
mentioned?
i know its silly

waiting for ur responce ..

thanks,
ja
 
Wow , thatks dude.
thatks Norman Jones ,VENKATARAMAN!!
thanks a lot.

is there anyway to "Rate the post" ?
just curious
 
Hey then dude,
got one doubt
say i need to calculate number of "m" present in the column.. its like
this

max, matter, mass, apple, orange...

and from this i need to count number of words starting with letter
"m".
how to do it?

waiting for ur responce.


thanks,
jay
 
Thanks Norman,
thanks a lot...

and one more
is there anyway to rate the post
 
I see you are posting from the Excel forum. However, the answers you
received are from the publick newsgroup

news://msnews.microsoft.com/microsoft.public.excel.programming

Excel forum just sucks in the information from there.

Unless someone has sandwich board information on the bottom of their post
like you have:
jayender.vs's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=28640
View this thread: http://www.excelforum.com/showthread.php?threadid=483035

the answer is probably from the newsgroup and not from the excel forum.
You can connect directly to usenet using the above link if you wish.

--
Regards,
Tom Ogilvy


"jayender.vs" <[email protected]>
wrote in message
news:[email protected]...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count number of "D" 1
how can i count multiple variables in multiple columns? 1
Countif if counted results are based on formula 6
Fill Right Variable Number of Columns, then Calculate Using Offset 6
Excel How to find the most common pairs and triplets numbers? 5
SUMPRODUCT 7
Count the Number of Files in a Folder 3
Count every group of numbers whose sum is zero & put number next toeach number 6

Back
Top