Solved

Excel Number of Tasks Formula

Posted on 2015-01-13
4
159 Views
Last Modified: 2015-01-13
i have an excel sheet and would like a formula to keep up with every time i add additional row to column "B"

also i created a "Done" filter and would like a formula that counts inprogress and Completed

any idea guys?
0
Comment
Question by:Jorge Ocampo
  • 2
4 Comments
 
LVL 92

Accepted Solution

by:
Patrick Matthews earned 350 total points
ID: 40547489
It's not entirely clear what you want.  A sample file would help.

In any event, these formulae will tell you how many of "Done", "In progress", and "Completed" there are in Col B:

=COUNTIF('worksheet name'!B:B,"Done")
=COUNTIF('worksheet name'!B:B,"In progress")
=COUNTIF('worksheet name'!B:B,"Completed")
0
 
LVL 92

Expert Comment

by:Patrick Matthews
ID: 40547502
You could also use a PivotTable, perhaps coupled with the techniques outlined here for automatically refreshing your PivotTable as your source data change:

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/A_3172-How-to-Automatically-Update-Your-PivotTables-and-PivotCharts.html
0
 
LVL 2

Author Comment

by:Jorge Ocampo
ID: 40547632
these is exactly what i wanted =COUNTIF('worksheet name'!B:B,"Completed") thanks

is it possible to add two words for the same formula

=COUNTIF('worksheet name'!B:B,"COMPLETED, INPROGRESS") ????trying to get a sub total of combine words
0
 
LVL 23

Assisted Solution

by:DanCh99
DanCh99 earned 150 total points
ID: 40547735
Just add 'em up...
=COUNTIF('worksheet name'!B:B,"COMPLETED")+COUNTIF('worksheet name'!B:B,"INPROGRESS")
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now