Solved

Meaning of excel formula

Posted on 2011-09-30
8
213 Views
Last Modified: 2012-08-14
Can someone please tell me what is following formula doing?

=COUNTIF('\\path of excel file (hidden) '!G4:G82, "=Career Fair")

I have also attached the image with path hidden.

Any help would be highly appreciated.
excel-question.PNG
0
Comment
Question by:KoolAsIce
  • 4
  • 3
8 Comments
 
LVL 12

Accepted Solution

by:
kgerb earned 500 total points
ID: 36894051
If any of the cells from G4 to G82 in the external excel file equals the words "Career Fair" it will include that cell in the total count

Kyle
0
 

Author Comment

by:KoolAsIce
ID: 36894063
hi Kyle,

Thanks for your reply!

That's what I thought too, but I got blown away by the use of ! mark. Could you please tell me why is there an exclamation mark in the range? Im a excel newbie ;)

Thanks,
Prem
0
 
LVL 70

Expert Comment

by:KCTS
ID: 36894065
Its counting how many of the cells in the range G4:G82 in the file have 'Career Fair' in them
 
0
 
LVL 12

Expert Comment

by:kgerb
ID: 36894070
so...essentially it's totaling the number of cells which contain the words "Career Fair".

Kyle
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

Author Comment

by:KoolAsIce
ID: 36894079
Thanks Kyle! I really appreciate for your quick help!
0
 
LVL 12

Expert Comment

by:kgerb
ID: 36894080
The exclamation point is used when referencing other sheets.  For example if I want to add cells A1 and B1 on sheet2 then I would do =Sheet2!A1 + Sheet2!B1.  make sense?

Kyle
0
 
LVL 12

Expert Comment

by:kgerb
ID: 36894101
You're welcome:)
0
 

Author Comment

by:KoolAsIce
ID: 36894103
totally makes sense :) Once again thanks Kyle!
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

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 …
Outlook Free & Paid Tools
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

707 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

18 Experts available now in Live!

Get 1:1 Help Now