Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
Solved

# Excel Number of Tasks Formula

Posted on 2015-01-13
Medium Priority
177 Views
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
Question by:Jorge Ocampo
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 2

LVL 93

Accepted Solution

Patrick Matthews earned 1400 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 93

Expert Comment

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

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

Danny Child earned 600 total points
ID: 40547735
=COUNTIF('worksheet name'!B:B,"COMPLETED")+COUNTIF('worksheet name'!B:B,"INPROGRESS")
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
###### Suggested Courses
Course of the Month7 days, 19 hours left to enroll