Question: I've got a Microsoft form feeding into a live Excel document - and I'm trying to make a table on a new worksheet (Form1) that totals certain submissions based on a criteria. I've been using SUMIFS to count conditionals - but I think because Microsoft Form saves these as 'text' values - all my sums have an apostrophe in front of them and my SUMIFS are totally 0.

This is a version of my set-up:

| A | B | C |
| --- | --- | --- |
| A | Yes | '10 |
| C | Ye | '15 |
| G | Yes | '10 |
| A | No | '20 |
| A | Yes | '45 |

A and B are the values that I'm checking meet my condition. In this simplified example I want to sum up the totals (Column C) for every row that has an "A" in Column A and a "YES" in Column B.

My function is: `=SUMIFS(Form1!C:C,Form1!A:A, "A",Form1!B:B,"Yes")`

I'm not 100% it's the ' tripping me up - but fairly confident. I've tried exploring both SUMPRODUCT and trying to use LENS/RIGHT/ETC within the function to remove the first character...but no luck.

Any advice how I could do this without having to modify the original columns (since it's live data coming in via a form?).

Answer: 
You need to add keyup to your input and replace every time the '%' with '' then add it again
i think your code should look like this :
app.component.html

```
   <p>
  Percentage Directive <br/>
  <b>Example: </b> 0 to 100
</p>
<input type="textbox"  #box (keyup)="setvalue(box.value)"[(ngModel)]="InputValue" placeholder="example 22.2" >
 %

```

app.component.ts :

```
  setvalue(value) {
 this.InputValue = value.replace('%','')+"%"    
  }

```
I don't think it makes sense to add % directly, you can add it when you request it, if you want to display the page, you can use the pseudo element in the CSS display, so the code will be more flexible