Thanks this works perfectly, just a question though what is the need for the
-- in the formula?

"Jacob Skaria" wrote:

Try

=SUMPRODUCT(--(A1:A10011012),--(A1:A100<12089),C1:C100)

If this post helps click Yes
---------------
Jacob Skaria


"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