View Single Post
  #1   Report Post  
DAVID
 
Posts: n/a
Default sum cells with criteria

I want to do something like sumif(A1:A100,"<5",B1:B100). But now instead of
the constant 5 in the criteria I want to use a variable, means the value of
the cell C1. How can i DO IT?