countif ???

  • Thread starter Thread starter GazMo
  • Start date Start date
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 ???
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countifs or a pivot 1
Excel Help with dates 2
How to select the date? 4
Find the position of a date 6
dates of month automation 3
ContIF Formula Needed 3
Countif or sumif for cumulative sums,pivot table & chart 2
Date Lookup 8

Back
Top