Hi all,
I'm looking for some help with some code. What I'm trying to do is pretty easy to explain, I'm just not sure what's the most efficient way to do it.
help.xls
I attached an example of two of the worksheets that I would be using. One would have the census information (age, tenure, etc.) The other one is a volume analysis that counts how many people of a certain age there are. None of this I have a problem with, but what I need is an IF statement or something that will say: IF this person is 28, what is their salary? Then it would find their salary and add it to 'Total Salary' (C11 in the uploaded document).
In simple terms: determine how much people at a certain age make in total.
If I need to explain more, I'd love to.
Thanks for any help.
Bookmarks