counting string information help please

[prizefighter]

hi

i have a column of departments and a coloumn of courses

its a list of about 400 entries where the 8 different departments have sent
people on 10 different courses

what would be the best way to have a running total of how many people say of
department "X" have been on a particualr course

thank you for any help you can give

paul

 

[Frank Kabel]

Hi
try
=SUMPRODUCT((A1:A1000="Department X")*(B1:B1000="Course_Name A"))

 

[prizefighter]

excellent !!!

thx for a quick responce

paul

Hi
try
=SUMPRODUCT((A1:A1000="Department X")*(B1:B1000="Course_Name A"))