Help With SUMIF Function
 

I have a formula that goes down col. A such that it inserts an "X"
(without quotes) in the cells if a certain criteria is met in data
inserted in other colums.

I am now trying to count how many cells in col. A have the "X" using
the SUMIF function. I keep on getting 0 (zero) as the result.

Here is the formula that I am using in cell B1:

=SUMIF(A1:A10000,"X")

What am I doing wrong?
--
tb

Help With SUMIF Function
 

Hi,

Am Fri, 28 Aug 2015 13:49:37 +0000 (UTC) schrieb tb:

=SUMIF(A1:A10000,"X")

try:
=COUNTIF(A1:A10000,"X")


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Help With SUMIF Function
 

On 8/28/2015 at 8:55:34 AM Claus Busch wrote:

Hi,

Am Fri, 28 Aug 2015 13:49:37 +0000 (UTC) schrieb tb:

=SUMIF(A1:A10000,"X")

try:
=COUNTIF(A1:A10000,"X")


Regards
Claus B.

Thanks!!

--
tb