View Single Post
  #1   Report Post  
Jamie A Miller
 
Posts: n/a
Default SumIf Function using multiple criteria

I am trying to sum the amounts in column A based on the figure in Column B.
I want the formula to sum Column A if the value in Column B is between 99 and
200. For some reason, I am having trouble with the multiple criteria part of
this. Is there a way to do this, another function, or anything?