Thread: Formula Question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
carl carl is offline
external usenet poster
  
Posts: 42
Default Formula Question

For this formula

=IF(COUNTIF(A2:A19;"<2")=0;0;AVERAGE(IF(A2:A19<2;A BS(B2:B19-C2:C19))))

How would I modify so it does the calculation only when A2:A19 is
between 2 and 5 (including 2) ?

Thank you in advance.


Reply With QuoteReply With Quote