For Any Use & On Any Platform
Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.
Course Of The Month
6 days, 15 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Excel 2007 count items
Posted on 2014-04-01
I have a spreadsheet with two tabs. One is labeled "MAIN" and the other is labeled "Appraisal_Status".
On the MAIN tab in Col A7 I have "Appraisal Assessment and Rating Status" and there are three items that it can be.
In Progress
Not Initiated
COMPLETED
BLANKS
On the Appraisal_Status tab Col F is labeled "Appraisal Assessment and Rating Status".
I need to count In Progress, Not Initiated, Completed & BLANKS and display the count on the Main tab.
Please see the attached.
Thanks.
TEMP-Appraisal-Status.xlsx
On the MAIN tab in Col A7 I have "Appraisal Assessment and Rating Status" and there are three items that it can be.
In Progress
Not Initiated
COMPLETED
BLANKS
On the Appraisal_Status tab Col F is labeled "Appraisal Assessment and Rating Status".
I need to count In Progress, Not Initiated, Completed & BLANKS and display the count on the Main tab.
Please see the attached.
Thanks.
TEMP-Appraisal-Status.xlsx
[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
- Learn & ask questions
5
4-
3
- +1
14 Comments
See attached
TEMP-Appraisal-Status-Jigs.xlsx
TEMP-Appraisal-Status-Jigs.xlsx
See attached
TEMP-Appraisal-Status.xlsx
TEMP-Appraisal-Status.xlsx
Active 2 days ago
You can use a Pivot Table.
Select the column, then Insert Pivot Table.
Click Finish...
Then in the Right Pane, drag the item from top section to Columns section below. Drag again from top to Values section below.
Should give counts of each without formulas.
Select the column, then Insert Pivot Table.
Click Finish...
Then in the Right Pane, drag the item from top section to Columns section below. Drag again from top to Values section below.
Should give counts of each without formulas.
Active 2 days ago
Another way to count blanks without having to define range...
=MATCH(REPT("z",255),Appra
=MATCH(REPT("z",255),Appra
Mr. NBVC,
Will you pls explain How your Formula Works i.e. =MATCH(REPT("z",255),Appra
Just for knowledge sake, your formula is perfect.
Thanks
Will you pls explain How your Formula Works i.e. =MATCH(REPT("z",255),Appra
Just for knowledge sake, your formula is perfect.
Thanks
Mr.CMILLER,
Mr.NBVC is formula is more appropriate than me as if you add some in range you have to modify my formula for blank. but if you use "=MATCH(REPT("z",255),Appr
mi right Mr.NBVC?
Thanks
Mr.NBVC is formula is more appropriate than me as if you add some in range you have to modify my formula for blank. but if you use "=MATCH(REPT("z",255),Appr
mi right Mr.NBVC?
Thanks
Active 2 days ago
MATCH(REPT("z",255),Apprai
Featured Post
![[Webinar] Learn How Hackers Steal Your Credentials](https://filedb.experts-exchange.com/files/public/2017/5/21/e0b7778f-e79e-4b5d-9ec6-5496e40be42e.png)
Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Suggested Courses
Course of the Month6 days, 15 hours left to enroll
724 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.