Results 1 to 3 of 3

count cells but only with specific criteria

Threaded View

  1. #1
    Registered User
    Join Date
    10-23-2008
    Location
    USA
    Posts
    78

    count cells but only with specific criteria

    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!!
    Last edited by bmunoz64; 04-05-2009 at 07:22 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1