count number of "D"
 

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


--
jayender.vs
------------------------------------------------------------------------
jayender.vs's Profile: http://www.excelforum.com/member.php...o&userid=28640
View this thread: http://www.excelforum.com/showthread...hreadid=483035

count number of "D"
 

=COUNTIF(A1:A7,"*d")

assuming these entries are in a1 to a7



"jayender.vs"
wrote in message
...

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


--
jayender.vs
------------------------------------------------------------------------
jayender.vs's Profile:
http://www.excelforum.com/member.php...o&userid=28640
View this thread: http://www.excelforum.com/showthread...hreadid=483035

count number of "D"
 

Hi Jayender,

Try:

=COUNTIF(C:C,"m")

=COUNTIF(D:D,"d")


---
Regards,
Norman



"jayender.vs"
wrote in message
...

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


--
jayender.vs
------------------------------------------------------------------------
jayender.vs's Profile:
http://www.excelforum.com/member.php...o&userid=28640
View this thread: http://www.excelforum.com/showthread...hreadid=483035

count number of "D"
 

R.VENKATARAMAN Wrote:
=COUNTIF(A1:A7,"*d")

assuming these entries are in a1 to a7

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

--
jayender.v
-----------------------------------------------------------------------
jayender.vs's Profile: http://www.excelforum.com/member.php...fo&userid=2864
View this thread: http://www.excelforum.com/showthread.php?threadid=48303

count number of "D"
 

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

is there anyway to "Rate the post" ?
just curious

--
jayender.v
-----------------------------------------------------------------------
jayender.vs's Profile: http://www.excelforum.com/member.php...fo&userid=2864
View this thread: http://www.excelforum.com/showthread.php?threadid=48303

count number of "D"
 

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


--
jayender.vs
------------------------------------------------------------------------
jayender.vs's Profile: http://www.excelforum.com/member.php...o&userid=28640
View this thread: http://www.excelforum.com/showthread...hreadid=483035

count number of "D"
 

Hi Jayender,

Try:

=COUNTIF(C:C,"m*")


---
Regards,
Norman



"jayender.vs"
wrote in message
...

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


--
jayender.vs
------------------------------------------------------------------------
jayender.vs's Profile:
http://www.excelforum.com/member.php...o&userid=28640
View this thread: http://www.excelforum.com/showthread...hreadid=483035

count number of "D"
 

Thanks Norman,
thanks a lot...

and one more
is there anyway to rate the post

--
jayender.v
-----------------------------------------------------------------------
jayender.vs's Profile: http://www.excelforum.com/member.php...fo&userid=2864
View this thread: http://www.excelforum.com/showthread.php?threadid=48303

count number of "D"
 

select any empty cell and type that formula



"jayender.vs"
wrote in message
...

R.VENKATARAMAN Wrote:
=COUNTIF(A1:A7,"*d")

assuming these entries are in a1 to a7

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

waiting for ur responce ..

thanks,
jay


--
jayender.vs
------------------------------------------------------------------------
jayender.vs's Profile:
http://www.excelforum.com/member.php...o&userid=28640
View this thread: http://www.excelforum.com/showthread...hreadid=483035

count number of "D"
 

No way but to respond with your appreciation which you have.

--
Regards,
Tom Ogilvy


"jayender.vs"
wrote in message
...

Thanks Norman,
thanks a lot...

and one more
is there anyway to rate the post?


--
jayender.vs
------------------------------------------------------------------------
jayender.vs's Profile:
http://www.excelforum.com/member.php...o&userid=28640
View this thread: http://www.excelforum.com/showthread...hreadid=483035

count number of "D"
 

I see you are posting from the Excel forum. However, the answers you
received are from the publick newsgroup

news://msnews.microsoft.com/microsof...el.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...o&userid=28640
View this thread: http://www.excelforum.com/showthread...hreadid=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"
wrote in message
...

Thanks Norman,
thanks a lot...

and one more
is there anyway to rate the post?


--
jayender.vs
------------------------------------------------------------------------
jayender.vs's Profile:
http://www.excelforum.com/member.php...o&userid=28640
View this thread: http://www.excelforum.com/showthread...hreadid=483035