LinkBack URL
About LinkBacks
EDIT: mdw's is best... sneaky mdw!
If you have only the 4 options and you may have blanks then:
=COUNTA(Sheet2!A:A)-COUNTIF(Sheet2!A:A,"Active")
else
=SUM(COUNTIF(Sheet2!A:A,{"Cancelled","Completed","Suspended"}))
EDIT: mdw's is best... sneaky mdw!
If you have only the 4 options and you may have blanks then:
=COUNTA(Sheet2!A:A)-COUNTIF(Sheet2!A:A,"Active")
else
=SUM(COUNTIF(Sheet2!A:A,{"Cancelled","Completed","Suspended"}))
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks