sumif where cirtiera start with 224

[Stani]

=SUMMER.HVIS.SETT(Transer!$G:$G;Transer!$A:$A;$A$4;Transer!$D:$D;formel!$B4;Transer!$M:$M;"224*")

In the last criteria im trying to only count where numbers starts with 224, why doesnt it work? It reply 0.

 

[konew1]

Hi
It appears that you are using a text structure for numeric data

 

[FDibbins]

Not familiar with your language, but if that is as SUMIF as your title says, you are only allowed 3 arguments...
=SUMIF(criteria-range, criteria, sum range)

If you are using sumifS(), then you cannot use a wildcard like that for numbers, try SUMPRODUCT instead (or use a helper to pull out those 3 numbers). Below is a simplified version of what I mean...
K1=SUMPRODUCT(--(LEFT($H$1:$H$8,2)="22"),(I1:I8))
[Table="width:, class:grid"][tr][td] [/td][td]

H​

[/td][td]

I​

[/td][/tr]
[tr][td]

1​

[/td][td]

2212​

[/td][td]

10​

[/td][/tr]

[tr][td]

2​

[/td][td]

2213​

[/td][td]

20​

[/td][/tr]

[tr][td]

3​

[/td][td]

2214​

[/td][td]

30​

[/td][/tr]

[tr][td]

4​

[/td][td]

2215​

[/td][td]

40​

[/td][/tr]

[tr][td]

5​

[/td][td]

2312​

[/td][td]

50​

[/td][/tr]

[tr][td]

6​

[/td][td]

2313​

[/td][td]

60​

[/td][/tr]

[tr][td]

7​

[/td][td]

2314​

[/td][td]

70​

[/td][/tr]

[tr][td]

8​

[/td][td]

2315​

[/td][td]

80​

[/td][/tr]
[/table]