Results 1 to 8 of 8

Sumif?

Threaded View

  1. #1
    Registered User
    Join Date
    09-09-2008
    Location
    Southampton
    Posts
    19

    Sumif?

    On the attached, Ithe Overdue By column is the number of days that an item was overdue by.

    I need to find the amount of times an item was overdue, per Estimator. If I do =SUMIF(D1:D10,D2,I1:I10) then it gives 17 (total days overdue), but I need it to give 3 (the number of times that an item was overdue for Jim).

    I put =IF(I1:I10=" ","","1") in the next column, then did the same sumif formula as above for that column, but it comes up with 0.

    Can anyone help?

    ETA: Example starts from column D, and H is hidden.
    Attached Images Attached Images
    Last edited by NBVC; 04-03-2009 at 11:20 AM.

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