Countif / Sumif In Excel

[andyGTBristol]

I have a spreadsheet in Excel and am trying to count the number of issues per dept. that have gone past due.

What is the best formula to use ?
Depts are in column G and dates in column L

Thanks

[Old_Geezer]

No expert but I think I'd have a column for one minus the other and then see the help file for what counts negative values ? Although I'm sure your way will be much neater.

[Aquariel]

Firstly, I would add an extra column (e.g. in M) to calculate if something is overdue, e.g. 1 if overdue, 0 if not. Then you can do a SUMIF function on the department column using the new overdue indicator in column M to add them up.

So your formula would be something like =SUMIF(G1:G50,"dept name",M1:M50)

That will then add up all the overdue dates for "dept name".

(I hope that formula comes out ok on here, they sometimes don't!)