Thanks

Charlie

On Thu, 22 Mar 2007 16:42:36 -0600, JE McGimpsey wrote:

SUMPRODUCT ignores non-numeric values like TRUE/FALSE so you have to
coerce your calculation into 1/0, e.g.:

=SUMPRODUCT(--(C2:C24="A"))

However, for one column at a time, you might as well use

=COUNTIF(C2:C24,"A")

In article ,
Charliec wrote:

I have three columns in a spreadsheet that can contain "A", "Y", "C",
respectively. I'm trying to get a total of each column as to how many
time the A,Y, C, occurs in each column - there is a separate column
for each letter. I tried setting up the formula as follows:

=SUMPRODUCT(C2:C24="A")

But, even though I have an A in some of the cells from CD:C24, the
total still produces a 0 total.

Any suggestions on the formula is appreciated.

Thanks
Charlie
************************************************** ****
Charliec
************************************************** ****
Charliec