receive one value using two or more criteria

B

billdad

Using a spreadsheet with 12 columns and 500 rows that lists staff names,
positions, work locations, and adjacent columns of data related to each name
on the list. First three column headers are Position (10 different positions
listed), Location (9 different locations listed) and Name (500 names, ie:
Smith, Joe). I want to produce the number of staff in a specific position at
a specifc location. For example, the result I want will identify how many
Directors are at the "North" Location, how many at the "South" location, etc.

What formula will work? I haven't been able to get vlookup, or any "count"
formula to work. The directive I have received is to produce a report
itemizing the numbers of positions across the 9 locations for 500+ staff.
Help.

Thanks.
 
D

Dave

Hi,
Perhaps something like:
=SUMPRODUCT(--(A2:A500="Director")*(B2:B500="North")*(ISTEXT(C2:C500)))
Regards - Dave.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top