In your source sheet you could insert a new column D, and in D3 you
can put this formula:
and copy this down by double-clicking the fill handle (the small black
square in the bottom right corner of the cursor).
Then in your summary sheet you could use columns A, B and C to record
the city, state and job code, and in D3 you could have this formula:
Then copy this across to G3.
Hope this helps.
> city>st 爅c
> atl 爂a 123 ??5 ??gt;30>?17 ?10
> from that i am populating a summary sheet for my clients which>are assigned
> multiple locations (cities) and titles>(j>b codes).
> So i have a client that is assigned atlanta, ga for custom>r assistants
> which is job code 123...and i need to retrieve the number of >andidates in
> each folder/category in a snapshot/summary and i want to do >his for each
> location/cl>en>/job code
> i need a formula to go out into the raw data to find the cit>...then look
> for a specified job code then populate the cell below each cat>gory (inbox,
> intv, sel, hired) with the corresponding number of candidat>s in each of
> these categories. so that i can summarize each of my clien>s >ocations.
> i have tried ifs & ands & also looked at indirect & offset but>am having no
> luck...can anyone help me? 爐hanks!