Count a numbers of entries in a given month ?

S

Svoger

I need to count a numbers of entries in a given month and then I have to
compare with another set of entries that has to be greater than a certain
month. I also has to count the numbers of empty cells. Can I use a nested IF
function ?
 
D

Don Guillett

I'm not clear on exactly what you want but maybe idea will help. Modify to
suit.
If your col A is DATES and you want April

=sumproduct((month(a2:a200)=4)*(month(b2:b200)>2))
 
E

ewan7279

If you want to count blanks in a range, use '=COUNTIF(A1:A10,"")'. A1 to A10
is the range you want to enter.
 

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

Section and Page numbering 0
How to count the numbers in a Word document? 0
Recover Outlook calendar entry 1
Page numbering with Merged Document and IF statements 1
Nested if then statement 2
Inconsistent formatting of section numbers 0
Space at end of multi page list to accommodate new entries 1
Sum of Numbers of a Rolling 6 month Period range 0

Top