Thread: Need to sum a set of number with criteria "SW/**" as a subtotal
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kj108 kj108 is offline
external usenet poster
  
Posts: 3
Default Need to sum a set of number with criteria "SW/**" as a subtotal
Need to sum a set of number with criteria "SW/**" as a subtotal

Something like

SUMIF(H2:H470) "SW?**", SUBTOTAL(9, J2:J40))
Reply With QuoteReply With Quote