SUMIF within a range
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)
|