aegliveinterns
New Member
- Joined
- Apr 28, 2010
- Messages
- 11
Hey Mr. Excel. I'm trying to create some nested functions if possible. I keep track of the types of internships we have available at my company and how many spots we're offering in a sheet in the attached workbook called Internship Report. Numbers from the first sheet, Internships, should be transferred automatically to the Internship Report Sheet.
I want a function with the following logic:
IF Internships! G:G = Approved, IF A:A = Los Angeles (or any other office), how many unique rows (to get how many unique internships offered)
and this function as well:
IF Internships! G:G = Approved, IF A:A = Los Angeles, SUM C:C (to get total internship spots)
Can you guys help me with these functions?
I want a function with the following logic:
IF Internships! G:G = Approved, IF A:A = Los Angeles (or any other office), how many unique rows (to get how many unique internships offered)
and this function as well:
IF Internships! G:G = Approved, IF A:A = Los Angeles, SUM C:C (to get total internship spots)
Can you guys help me with these functions?