Meaning of excel formula

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
KoolAsIceAsked:
Who is Participating?
 
kgerbConnect With a Mentor Chief EngineerCommented:
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
 
KoolAsIceAuthor Commented:
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
 
KCTSCommented:
Its counting how many of the cells in the range G4:G82 in the file have 'Career Fair' in them
 
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
kgerbChief EngineerCommented:
so...essentially it's totaling the number of cells which contain the words "Career Fair".

Kyle
0
 
KoolAsIceAuthor Commented:
Thanks Kyle! I really appreciate for your quick help!
0
 
kgerbChief EngineerCommented:
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
 
kgerbChief EngineerCommented:
You're welcome:)
0
 
KoolAsIceAuthor Commented:
totally makes sense :) Once again thanks Kyle!
0
All Courses

From novice to tech pro — start learning today.