Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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 ... 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
|
|||
|
|||
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 ... 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
|
|||
|
|||
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
|
|||
|
|||
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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
Count and Sum Total occurrances of two specific numbers | Excel Worksheet Functions | |||
count duplicate (or, inversely, unique) entries, but based on a condition | Excel Worksheet Functions | |||
count a group of numbers but do not count duplicates | Excel Worksheet Functions | |||
PivotTable - Count by Month | Excel Worksheet Functions |