|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 4th, 2005, 07:45 AM
|
|||
|
|||
Count a numbers of entries in a given month ?
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 ? 
|
|
#2
April 4th, 2005, 01:51 PM
|
|||
|
|||
|
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)) -- Don Guillett SalesAid Software "Svoger" wrote in message news  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 ?
|
|
#3
April 4th, 2005, 02:11 PM
|
|||
|
|||
|
Hi
I think I have solved the problem. thanks Susanne "Don Guillett" wrote: 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)) -- Don Guillett SalesAid Software "Svoger" wrote in message news 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 ?
|
|
#4
April 4th, 2005, 02:19 PM
|
|||
|
|||
|
If you want to count blanks in a range, use '=COUNTIF(A1:A10,"")'. A1 to A10
is the range you want to enter. "Svoger" wrote: 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 ?
|
|
#5
April 5th, 2005, 12:52 AM
|
|||
|
|||
|
You could even use '=COUNTBLANK(A1:A10)'
"ewan7279" wrote in message ... If you want to count blanks in a range, use '=COUNTIF(A1:A10,"")'. A1 to A10 is the range you want to enter. "Svoger" wrote: 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 ?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Count specific entries in records in report fed by xtab query | Bill Pauley | Setting Up & Running Reports | 11 | April 2nd, 2005 05:18 AM |
| How do I count a range of numbers in a column | SLB | General Discussion | 3 | October 21st, 2004 05:23 PM |
| Count the numbers of 1 column where an other column meets a creteria? | Michel | Worksheet Functions | 3 | April 19th, 2004 06:29 PM |
Linear Mode
