Excel Number of Tasks Formula

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?
LVL 2
Jorge OcampoAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Patrick MatthewsConnect With a Mentor Commented:
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
 
Patrick MatthewsCommented:
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
 
Jorge OcampoAuthor Commented:
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
 
Danny ChildConnect With a Mentor IT ManagerCommented:
Just add 'em up...
=COUNTIF('worksheet name'!B:B,"COMPLETED")+COUNTIF('worksheet name'!B:B,"INPROGRESS")
0
All Courses

From novice to tech pro — start learning today.