KoolAsIce
asked on
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
=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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Its counting how many of the cells in the range G4:G82 in the file have 'Career Fair' in them
so...essentially it's totaling the number of cells which contain the words "Career Fair".
Kyle
Kyle
ASKER
Thanks Kyle! I really appreciate for your quick help!
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
Kyle
You're welcome:)
ASKER
totally makes sense :) Once again thanks Kyle!
ASKER
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