Try this:

=SUMIF(A1:A3,"<12089",C1:C3) - SUMIF(A1:A3,"<=11012",C1:C3)

Hope this helps.

Pete

On Aug 4, 9:53*am, Nic wrote:
I have a list of accounts and account numbers eg

* * * * * * A * * * * * * * * * * * B * * * * * * * * * * * * *C
1 * * * *11012 * * * * * *Personal exp * * * * * * 12000
2 * * * *11019 * * * * * *Business exp * * * * * * 10000
3 * * * *12089 * * * * * *Hotel exp * * * * * * * * *25000

i want to sum coulmn C if coulmn A falls between 11012 and 12089 the result
should show 10000

I have tried sumif(A1:A3,11012<12089,C1:C3) value is shown as 0 which is
wrong.

I have also tried the sum(if( function but that will only work with one
coulmn.

Any ideas please help
Thanks