Sum based on arguements from multiple columns

[Craig]

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

 

[Mike H]

Try

=SUMPRODUCT((A1:A20="Winter Only")*(ISNUMBER(B1:B20)))

Mike

 

[Craig]

That worked. Thanks Mike

Try

=SUMPRODUCT((A1:A20="Winter Only")*(ISNUMBER(B1:B20)))

Mike