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?
 
kgerbChief 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
 
Brian PiercePhotographerCommented:
Its counting how many of the cells in the range G4:G82 in the file have 'Career Fair' in them
 
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.