As per other post

=SUM(COUNTIF(A:A,{"S","M"}))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Grenaa Music school" wrote in
message ...
Hi out there
I need programming help for making
s = 1
and
M = 1

S meaning Sick
M meaning missing

but excel still has to multiply a certain nummer with 1.

All the best
GRenaa Music school
--
Grenaa Music School
Denmark