Sumproduct formula issue

[ARGK]

Hi Guys
I am struggling with a formula to meet the following criteria:
1. Column L in Final Data tab = Architect
2. Column M in Final Data tab = SSCL Supply Organisation
3. Column I on Final Data tab = 9-2014
Basically I am trying to count how many resource types are being used each month. There will be multiple entries of the same name against the same resource type. for example, if there are three entries for Joe Bloggs who is an Architect in Sep 14 I only want to count that as one entry.
I attach a sample workbook for information.
Many thanks for your help/guidance.
Tony

[boopathiraja]

How abt using countifs ?

Please Login or Register  to view this content.

[ARGK]

Hi
many thanks for nyour quick response. I started off with COUNTIFS but it does not give me the count of people. For example the COUNTIF formula you provided give me a figure of 10 - 4 entries for person 1, 4 entries for person 2 and 2 entries for person 3. Whereas I want the formula to give me a figure of 3 in this instance, i.e. the number of Architect Resources being utilised in September 14.
Thanks
Tony

[misrasomendra]

Hi,

Try below formula in B2 and copy across.

Please Login or Register  to view this content.

Note this is an array formula so must be entered with Ctrl+Shift+Enter.

[ARGK]

Hi misrasomendra
I am not sure I could have worked this formula out but it worked brilliantly.
Many thanks for your help.
Kind regards
Tony

[misrasomendra]

Hi Tony,

Thanks for the feedback, I hope you will give some reps for this.

Welcome back.

[ARGK]

Already done that. Thanks again.