S
steve_m
I've got a list of dates dd/mm/yyyy in column A and a list of the numbers in
column B which is related to the number of occurrences of something on each
date listed. There are some gaps in the dates ie. it is not a continuous
calendar list.
What I need to do is count the total number of occurrences in April 2010 for
example. I've tried using SUMPRODUCT but I'm stuck! I've managed to count the
number of times a date in April 2010 is listed but not the sum of number of
occurrences in April 2010 from the column B? Hopefully that is semi-clear?!!
column B which is related to the number of occurrences of something on each
date listed. There are some gaps in the dates ie. it is not a continuous
calendar list.
What I need to do is count the total number of occurrences in April 2010 for
example. I've tried using SUMPRODUCT but I'm stuck! I've managed to count the
number of times a date in April 2010 is listed but not the sum of number of
occurrences in April 2010 from the column B? Hopefully that is semi-clear?!!