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

Sum based on arguements from multiple columns
 

Try

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

Mike

"Craig" wrote:

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

Sum based on arguements from multiple columns
 

That worked. Thanks Mike

"Mike H" wrote:

Try

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

Mike

"Craig" wrote:

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