ExcelBanter - S and m equal to 1

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - S and m equal to 1 (https://www.excelbanter.com/excel-programming/352182-s-m-equal-1-a.html)

Grenaa Music school

S and m equal to 1

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

Bob Phillips[_6_]

S and m equal to 1

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

All times are GMT +1. The time now is 11:34 AM.