Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I cant get this formula to compute what I need. it works perfectly with only
one critera but I need more, We'll say colom A is a date, colom B is a name and colom I is a value, I need a formula that sums only when the date is X AND the name is Y. This sheet is used for calculating flight time on specific tail numbers on specifc days. I an get the formula to work when it is =SUMIF($B$2:$B$373,M10,$I$2:$I$373) but I cant get it to do both =SUMIF($a$:$a$373,v10,$I$2:$I$373), where V10 is a specific date, M is the Name, the date range is in A, and the value is in I thanks for the help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUMif or SUMproduct across multiple worksheets? | Excel Worksheet Functions | |||
Sumif with multiple worksheets | Excel Worksheet Functions | |||
Multiple Condition Sumif Formula | Excel Worksheet Functions | |||
Sumif over multiple columns | Excel Worksheet Functions | |||
Sum(if ... multiple conditions ... Interpretation? | Excel Discussion (Misc queries) |