Thread: adding/omitting/all the values prior to todays date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tleehh tleehh is offline
external usenet poster
  
Posts: 21
Default adding/omitting/all the values prior to todays date
using given formula by Otavio sum((B10:B20="s1")*(C10:C20<"x")*A10:A20),
how can it add all the values in colume A that is prior to todays date (dates
are in colume D).
Reply With QuoteReply With Quote