some basic questions on sumif, if with arrays
Posted by Figen on December 28, 2000 2:34 PM
these may be really boring for some of you but I am just learning excel and would appreciate your help.
name age salary car
allan 13 1000 audi
tracy 12 1200 opel
jenny 11 1000 opel
tammy 23 3400 audi
nick 45 4500 saturn
bruce 34 5600 bmw
hillary 24 1300 mercedes
eileen 25 1000 saturn
andrew 36 1200 porsche
I have the above lists that I created for practice and I would like to
1) sum up the salaries of people who are younger than 24. But I want to use 24 as a variable; meaning I also
want to be able to use the same function for different
ages by referencing another cell that has another age
stored in it.
2)list all the names of the people who earn less than or equal to $1200. I tried to do this as an array
formula but it did not work right.
3)Find the names of people who have any one of the cars listed in a different column. For example if I have a list in a column
I want to find the list of the people who own these
cars but this cars list may get really long so I want
to find a way of doing this without writing individual
if statements that match to the car names.
Many thanks in advance....