Excel query

[Guest]

I need to total up numbers in a column which correspond to a particular key
(e.g. number 1 = attended event, 2 = refused invitation etc); I need a
formula which selects particular numbers and ignores others so that I can get
an accurate total (all number 1s = all those who attended an event).

 

[Alan]

With the data in column A,
=COUNTIF(A:A,1) will count all the 1's
Regards,
Alan.

 

[Don Guillett]

have a look in the help index for COUNTIF or SUMIF