Thread: Sumif Criteria
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nic Nic is offline
external usenet poster
 
Posts: 25
Default Sumif Criteria

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