count

  • Thread starter Thread starter Bert
  • Start date Start date
B

Bert

Good evening,

in have the following

A1 B1
5e 6e

Is it possible to create a form that ill count in C1 A1..b1 and the answer
should 11e!

Thanks
Bert
 
Hello Aladin,
Thnaks for the reply,
when I use the your formula I have an error message, at ,""

I have to translate the formula into dutch into
=somproduct(--(vervangen(l5..r5;"e";"")))&"e"

Bert
 
Try:

=SOMPRODUCT(--(SUBSTITUEREN(A1:B1;"e";"")))&"e"

The assumption is that you have figures followed by an "e" in all cells of
the range of interest. If you also have empty cells, use:

=SOMPRODUCT(--(SUBSTITUEREN(0&A1:B1;"e";"")))&"e"
 
Hya Aladin,

Below is a part of the range. The 5e/6e are extra working hours for people.
When I use your formula it says to few argumnets for this formula.
5e 6,0 5e v z 7,0 7,0


In a cell I want to show the accountant what he he to pay extra. That's why
the 5e and 6e.
In this week this lady has worked extra on day 1 and three. Was free o day 4
and sick on day 5. Worked regular on day 2, 6 and 7

Thanks a lot

Bert
 
What is the expected total, given in A1:H1

{"5e",6,"5e","v","z",7,7,0}

where 0 stands for an empty cell?
 
I guess...

=SUM(IF(ISNUMBER(A1:H1),A1:H1,IF(RIGHT(A1:H1)="e",--SUBSTITUTE(A1:H1,"e","")
)))

will do. The formula needs to be confirmed with control+shift+enter, not
just enter.
 
Back
Top