Internship Tracking Workbook w/IF Statements

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?
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

sulakvea

Well-known Member
Joined
Jul 2, 2008
Messages
994
=sum(if(G:G="Approved")*(A:A="Los Angeles")=1,C:C,false))

entered as array, with ctrl+shift+enter
 

aegliveinterns

New Member
Joined
Apr 28, 2010
Messages
11
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. :confused:
 

sulakvea

Well-known Member
Joined
Jul 2, 2008
Messages
994
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
Joined
Apr 28, 2010
Messages
11
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!
 

Forum statistics

Threads
1,136,968
Messages
5,678,866
Members
419,787
Latest member
juanam

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top