# Internship Tracking Workbook w/IF Statements

#### aegliveinterns

##### New Member
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?

### Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

#### sulakvea

##### Well-known Member
=sum(if(G:G="Approved")*(A:A="Los Angeles")=1,C:C,false))

entered as array, with ctrl+shift+enter

#### aegliveinterns

##### New Member
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

##### Well-known Member
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

##### New Member
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!

Replies
1
Views
1K
Replies
2
Views
1K
Replies
0
Views
290
Replies
0
Views
694
Replies
8
Views
584

1,171,719
Messages
5,877,116
Members
433,232
Latest member
mobekie

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back