Results 1 to 2 of 2

Sumproduct

Threaded View

  1. #1
    Registered User
    Join Date
    09-22-2008
    Location
    markham
    Posts
    52

    Sumproduct

    Hi,

    I would like to count the number of days a job has been posted according certain criteria - <35days, 36-60 days, 61-90 days and by department (legal, finance, HR).

    I have the formula in the <35 days column, and a formula that doesn't work for the others.

    In addition, I am trying to count working days only.

    I have attached a file for reference.

    Thank you.

    Brandy
    Attached Files Attached Files

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