View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alonso[_2_] Alonso[_2_] is offline
external usenet poster
 
Posts: 58
Default 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)