View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Craig Craig is offline
external usenet poster
 
Posts: 208
Default Sum based on arguements from multiple columns

I'm sure this is easy but i've got a mental block today. I have a spreadsheet
for recording the dates of when hedges were cut. Column A shows the
regularity of cut. It's either 'Summer & Winter' or 'Winter Only'. Column B
shows the date it was cut. All i want to do is count the number of cells in
Column B that show a date but only if Column A shows the text 'Winter Only'

Thanks in advance