Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUMIF with criteria | Excel Worksheet Functions | |||
SUMIF Criteria | Excel Worksheet Functions | |||
SUMIF with four criteria | Excel Worksheet Functions | |||
Sumif with 2 criteria | Excel Discussion (Misc queries) | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions |