S & M equal to 1
 

I need
S = 1
M= 1

Ex:
S meaning sick
M meaning missing

but excell still multiply a certain nummer with 1, when i write S or M

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

S & M equal to 1
 

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Grenaa Music school" wrote in
message ...
I need
S = 1
M= 1

Ex:
S meaning sick
M meaning missing

but excell still multiply a certain nummer with 1, when i write S or M

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

S & M equal to 1
 

Sounds like this may be a formula question. Not sure.

If "S" and "M" entries are in column B and you're trying to get a total
number of "S" and "M", try these formulas.

In C1 or other Cell:
=COUNTIF(B:B,"M")

In another cell:
=COUNTIF(B:B,"S")

If this is not what you're looking for, please repost.
HTH,
Paul

"Grenaa Music school" wrote in
message ...
I need
S = 1
M= 1

Ex:
S meaning sick
M meaning missing

but excell still multiply a certain nummer with 1, when i write S or M

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

S & M equal to 1
 

Hi,
I don't fully understand your question so can you give an example?

"Grenaa Music school" wrote:

I need
S = 1
M= 1

Ex:
S meaning sick
M meaning missing

but excell still multiply a certain nummer with 1, when i write S or M

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

S & M equal to 1
 

Hi
I´ll try

A teacher teaches a student.
Every lesson is 25 min.
If the student appears
he just write
1
in a columm.
At the end of the month he has written a certain amount 1´s ..!
=SUM(C6:N6)*B6
B6 is 25
and from C6 to N6 you can put in 1
BUT
If the student doesn´t appear get sick or whatever
we need to know, but we need to still pay the teacher aka we need to collect
minuts.
So
S (meaning Sick)
M (meaning missing)
just have the same effect as if you write 1
aka
S = 1
M = 1
and it multiplies into ex. 10 (llessons)* 25 min. = 250 min.
I´m not and expert at all, so I have to explain it in a very "nonexpert" way.

All the Best
SBX
Grenaa Music Shcool

I´ll try out the other suggestions!
--
Grenaa Music School
Denmark


"Toppers" wrote:

Hi,
I don't fully understand your question so can you give an example?

"Grenaa Music school" wrote:

I need
S = 1
M= 1

Ex:
S meaning sick
M meaning missing

but excell still multiply a certain nummer with 1, when i write S or M

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

S & M equal to 1
 

=sum(countif(C6:N6,{"S","M",1}))*B6

--
Regards,
Tom Ogilvy


"Grenaa Music school" wrote in
message ...
Hi
I´ll try

A teacher teaches a student.
Every lesson is 25 min.
If the student appears
he just write
1
in a columm.
At the end of the month he has written a certain amount 1´s ..!
=SUM(C6:N6)*B6
B6 is 25
and from C6 to N6 you can put in 1
BUT
If the student doesn´t appear get sick or whatever
we need to know, but we need to still pay the teacher aka we need to
collect
minuts.
So
S (meaning Sick)
M (meaning missing)
just have the same effect as if you write 1
aka
S = 1
M = 1
and it multiplies into ex. 10 (llessons)* 25 min. = 250 min.
I´m not and expert at all, so I have to explain it in a very "nonexpert"
way.

All the Best
SBX
Grenaa Music Shcool

I´ll try out the other suggestions!
--
Grenaa Music School
Denmark


"Toppers" wrote:

Hi,
I don't fully understand your question so can you give an
example?

"Grenaa Music school" wrote:

I need
S = 1
M= 1

Ex:
S meaning sick
M meaning missing

but excell still multiply a certain nummer with 1, when i write S or M

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