Sumifs

[belzok]

Hi,

Having some problems with the linked SUMIFS statement.

http://r.office.microsoft.com/r/rli...02E59FC8B8!155&AllowInteractivity=False&kip=1

I am trying to sum the account values depeding on whether the account number falls into a from and to criteria which shows in A4 and B4.

I have shown the formulas I am using and it looks very much like the >= from the From criteria doesn't seem to work as expected, the sum should be £6910 and not £6410.

Am I missing something really stupid here??

I suspect it is the text formats and leading zero with the 090 that is giving me problems but I really can't see why.

Thanks,

Mark

 

[Robert Mika]

=sum(index($g$3:$g$102,match(a4,$f$3:$f$100,0)):index($g$3:$g$102,match(b4,$f$3:$f$102),0))