Help, I'm Struggling!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top