Thread: Conditional SUBTOTAL in XL210 Table
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
zvkmpw zvkmpw is offline
external usenet poster
  
Posts: 153
Default Conditional SUBTOTAL in XL210 Table
Still trying to find another way around the ugly INDICRECT
statement. ...

This may be off-topic, but but you might consider something like
=SUMIF(S3:S100000,"<",Q3:Q100000)
Reply With QuoteReply With Quote