Donate SIGN UP

Countif / Sumif In Excel

Avatar Image
andyGTBristol | 12:25 Wed 01st Jul 2015 | Technology
2 Answers
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
Gravatar

Answers

1 to 2 of 2rss feed

Best Answer

No best answer has yet been selected by andyGTBristol. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
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.
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!)

1 to 2 of 2rss feed

Do you know the answer?

Countif / Sumif In Excel

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.