Thread: SUM(IF(OR
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Bob is offline
external usenet poster
 
Posts: 972
Default SUM(IF(OR

Using an array, I need a formula for the following:

If B2 through B500 = A2
and
If E2 through E500 = "CT" or "NT"
then SUM H2 through H500

Thank you!

Bob