Hi,

Bit of a newbie here! I have several, simple, cells with mostly just
arranged data and few functions, only really =SUM functions.

I would like Excel to search the spreadsheet, find singular numerical values
then do a =SUM function! I'm really unsure how to do this.

The other thing I would like to do is for Excel to count a column of "x"s as
opposed to numbers. Can Excel just count how many "x"s are in a column of
cells then sum at the bottom?

Thanks in advance for your help.

Fybo.

=COUNTIF(A:A,"x")

will count all cells with an x

You could use a sumif on eacg sheet if you know what columns the values are
in

=SUMIF(A:A,"<10")

will SUM all values less than 10 in column A



--

Regards,

Peo Sjoblom


"Fybo" wrote in message
...
Hi,

Bit of a newbie here! I have several, simple, cells with mostly just
arranged data and few functions, only really =SUM functions.

I would like Excel to search the spreadsheet, find singular numerical
values
then do a =SUM function! I'm really unsure how to do this.

The other thing I would like to do is for Excel to count a column of "x"s
as
opposed to numbers. Can Excel just count how many "x"s are in a column of
cells then sum at the bottom?

Thanks in advance for your help.

Fybo.