countif ???

G

GazMo

I have a column of dates and a column for the number of days after a
event (using networkdays)

eg ...

Jan 3
Jan 1
Jan 3
Feb 2
Feb 2

Is there a formula that I can count the number of occurances of
number in each month - eg in Jan 2 occurances of 3 and 1 occurance o
1?

Help ???
 
A

Alex Delamain

You could use a series of sumproduct formulae - e.g.

=sumproduct((a1:a10="Jan")*(b1:b10=1)

however it might be simpler to use a pivot table with months and day
as the rows and heading
 
Top