Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
i'm trying to check within a range (u5:ab94) if there are values
based on the content in column A to identify if there is activity but it only return a 1 (used) if the numbers are in the first column (in this case: U) -the problem is that i have values in columns W, X, etc and it still returns a 0 (thus, saying NO action) ie: =IF(SUMIF(Programa!$A$5:$A$94,$M6,Programa!U5:AB94 )0,1,0) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUMIF Range | Excel Discussion (Misc queries) | |||
SUMIF sum range | Excel Worksheet Functions | |||
SUMIF Range Help | Excel Worksheet Functions | |||
How to use a range in SUMIF? | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |