Thread: place counta within fomula?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Seeker Seeker is offline
external usenet poster
  
Posts: 137
Default place counta within fomula?
Thus end row can auto change to the last row?
like
=SUMPRODUCT(--(A1:A"counta(A1:A65536)"="xxx"),--(E1:E"counta(A1:A65536)"="bbb"),(F1:F"counta(A1:A6 5536)"))
Regards
Reply With QuoteReply With Quote