using countifs in a large spreadsheet

[Pulzzed]

Have a large data spreadsheet in excel 2010. I’m trying to count items in a column that fall within a certain data range. =countifs(sheet1!$D$3:$D$1003,sheet1!$B$3:$B$1003,">="&B4,sheet1!$B$3:$B$1003,"<="&C4)
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Sheet1 D3 = items to count (there are empty cells)
Sheet1 B3 = date column
<o></o>
B3 and B4 are date ranges that I want my criteria to meet. For example: I need the total files for Feb. B3 = 2/1/2011 & C4 = 2/28/2011
<o></o>

 

[tinyskills13]

What is in column D? The countifs function only has an even number of arguments (i.e., =countifs(range1, criteria1, range2, criteria2)). You have 5 arguments currently. Are you trying to only perform countifs if there is a value in column D and the date falls between the range?

 

[Marcelo Branco]

Maybe

=COUNTIFS(Sheet1!$D$3:$D$1003,"<>",Sheet1!$B$3:$B$1003,">="&B4,sheet1!$B$3:$B$1003,"<="&C4)

M.

 

[Pulzzed]

What is in column D? The countifs function only has an even number of arguments (i.e., =countifs(range1, criteria1, range2, criteria2)). You have 5 arguments currently. Are you trying to only perform countifs if there is a value in column D and the date falls between the range?

Column D is the Date ranges.

 

[Pulzzed]

Thanks, it worked!

 

[Pulzzed]

Thanks Marcelo Branco, your formula worked!

 

[Marcelo Branco]

Thanks Marcelo Branco, your formula worked!

You are welcome and tks for the feedback

M.

 

[Pulzzed]

Maybe

=COUNTIFS(Sheet1!$D$3:$D$1003,"<>",Sheet1!$B$3:$B$1003,">="&B4,sheet1!$B$3:$B$1003,"<="&C4)

M.

It worked Marcelo. Thanks so much!