View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MojoBaer
 
Posts: n/a
Default How do I do a "between" in an IF statement?

I need to sum a column and the condition has multiple criteria:


SUMIF($G$16:$G$28, between 5 and 10, $E$16:$E$28)

how do I represent "between 5 and 10"?