Internship Tracking Workbook w/IF Statements

[aegliveinterns]

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?

 

[sulakvea]

=sum(if(G:G="Approved")*(A:A="Los Angeles")=1,C:C,false))

entered as array, with ctrl+shift+enter

 

[aegliveinterns]

Hey thanks for the quick response! It tells me there's an error with the code, and it directs me to the '"Approved"' part of it. This is when I tried entering as an array and regular, and with all and only the equation (minus the = sign) selected.

 

[sulakvea]

formula is missing a bracket
=sum(if((G:G="Approved")*(A:A="Los Angeles")=1,C:C,false))

try this. also, dont forget to indicate that its another sheet. so it would be:
=sum(if((Internships!G:G="Approved")*(A:A="Los Angeles")=1,C:C,false))

 

[aegliveinterns]

I have a feeling we've almost got it! When I put it in, I get a #NUM! error. How should I change the parameters to get it fixed? And thanks, sulakvea, this is extremely helpful!