adding cells
 

hello
In a cell I use A, B, OR C each mean a different type of study
at the end of each month I would like to add up each of them.
is there a forumla to do this

--
jladik
-----------------------------------------------------------------------
jladika's Profile: http://www.excelforum.com/member.php...nfo&userid=910
View this thread: http://www.excelforum.com/showthread.php?threadid=39795

adding cells
 

If you enter the values in column A then
=countif(A:A,"C")

Hope this helps
Rowan

"jladika" wrote:


hello
In a cell I use A, B, OR C each mean a different type of study
at the end of each month I would like to add up each of them.
is there a forumla to do this?


--
jladika
------------------------------------------------------------------------
jladika's Profile: http://www.excelforum.com/member.php...fo&userid=9104
View this thread: http://www.excelforum.com/showthread...hreadid=397959

adding cells
 

=COUNTIF(A1:A18,"a")
=COUNTIF(A1:A18,"b")
=COUNTIF(A1:A18,"c")

where A1:A18 is your range to searc

--
UofMo
-----------------------------------------------------------------------
UofMoo's Profile: http://www.excelforum.com/member.php...fo&userid=2648
View this thread: http://www.excelforum.com/showthread.php?threadid=39795