View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
qwerty
 
Posts: n/a
Default SumIF - problem with Criteria

=SUMIF($A$9:$A48,"<=16",D$9:D$48)

The above works.

But what I need to do is to have the "<=16" get the variable value 16 from a
cell. The cell address with the current value 16 is AH1 and is on the same
worksheet.

Sorry folks - I can't figure out how to do this. If I enter "<=16", I get
the correct value. If I enter "<=AH1", I get 0.