View Single Post
  #2   Report Post  
Fanatik
 
Posts: n/a
Default

=SUMIF(B:B,"X",A:A)

Assuming that column B contains all the Xs and column A contains the values
you want to sum.

Note instead of defining columns you can also define ranges.

"staysee" wrote:

I need to autosum all cells that have been marked "x"