count cells but only with specific criteria

**bmunoz64** · 04-05-2009, 06:21 PM

I have a column N that shows dates for the week of 3/30, but only want to count the cells that contain 4/1, 4/2, 4/3, 4/4 and 4/5, ignoring empty cells.

I have come up with

SUMIFS('Week of 0330 - Dashboard'!N2:N129,'Week of 0330 - Dashboard'!N2:N129, "=>4/1/2009", 'Week of 0330 - Dashboard'!N2:N129, "=>4/5/2009")

My calculation is returning 0 fvor some reason, when some of these cells have the april dates.

any idea what I am doing wrong?

Thanks for lighting my light bulb!!

**daddylonglegs** · 04-05-2009, 06:30 PM

Are you trying to count or sum? You surely don't want to sum the dates themselves as that formula suggests.....

either way you presumably want the last condition to be < rather than > , i.e.

"<=4/5/2009"

and the = sign always comes after the > or < so first condition should be

">=4/1/2009"