Sumif?

**JessicaK** · 04-02-2009, 12:19 PM

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.

**NBVC** · 04-02-2009, 01:22 PM

Try:

=SUMPRODUCT(--($D$1:$D$10=$D2),--($A$1:$A$10=$A2),$I$1:$I$10)

copied down

**JessicaK** · 04-03-2009, 06:32 AM

I put that in but it's coming up as 0.

**NBVC** · 04-03-2009, 09:18 AM

Maybe post the actual spreadsheet sample (.xls) instead of a .jpg

**JessicaK** · 04-03-2009, 10:00 AM

Here you go (thanks).

Actually I've just noticed that I didn't copy that formula down properly - however, it's giving me 17, and I need 3.

**NBVC** · 04-03-2009, 10:05 AM

See attached... You want to count... not sum.. right?

**JessicaK** · 04-03-2009, 10:15 AM

thank you!

**NBVC** · 04-03-2009, 10:28 AM

You are welcome....

Can you please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save