=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" <Fybo@discussions.microsoft.com> wrote in message
news:7162B9C4-BACF-453C-9F48-6B0EDA7677E4@microsoft.com...
> 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.
>