Counting Problem

[Excel Ron]

I am trying to figure out how to count the number of cells from one sheet to another. I was thinking a countif may work but I have two variables. I need to count the number of cells under two conditions, first variable is the name must match, the next is I only need to pull from this count if it falls between two dates (ex. 02/28/2011-02/28/2011. Any suggestions would be great.

Thanks,

Excel Ron

 

[AlisaA]

Which version of Excel are you using?

 

[barry houdini]

If you have Excel 2007 or later you could use COUNTIFS, e.g. if your dates are in column A and names in B then a formula like this

=COUNTIFS(A:A,">="&D2,A:A,"<="&E2,B:B,F2)

where D2 is start date, E2 end date and F2 contains a specific name

 

[Excel Ron]

Ok, what if I do not have the exact date in the the series (ex. I am looking for a date between 2/01/2011-02/28/2011 and most all of my dates are scattered during that month? I tried the formula with using the dates instead of the cell reference and it did not work. Any other suggestions? It is 2007 also.

Thanks,

Ron

 

[barry houdini]

The formula should work "as is" if you have the earlier date in D2, i.e. 2/01/2011, and the later date in E2 - 02/28/2011....or if you want the date in the formula

=COUNTIFS(A:A,">="&DATE(2011,2,1),A:A,"<="&DATE(2011,2,28),B:B,F2)

 

[Excel Ron]

Awesome, Thanks so much that totally worked!!