View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cachod1
 
Posts: n/a
Default formula to count based on data in two different cells/columns

Column A has dates
Column B has one of 5 variables (LTF, WC, Exp, an "X", or is blank)

At the bottom of column B, I need to calculate the total number of cells
with "LTF, WC, or Exp" that have a date in column A that is equal to or less
than today's date.

What formula will do this?