Formula that counts rows that match 2 criteria, but do not match another

[VivatMartin]

Hi again All!

I was wondering if there is a formula that would allow me to count how many rows there are that match a given paramater in E2:E3000 of "Inhouse", G2:G3000 of "Martin" and that does NOT count any that have in F2:F3000 "External" I know it is possible to count how many that match the first two parameters, using the formula:

=SUMPRODUCT(--(E2:E3000="Inhouse"),--(G2:G3000="Martin"))

But it is counting incorrectly as I want it to ignore entries with the F2:F3000 that reads "External"

Thanks
Martin

[thameem127]

Use countif function if not upload a file.

Thanks
Thameem

[Fotis1991]

Maybe.

=SUMPRODUCT((E2:E3000="Inhouse")*(G2:G3000="Martin")*(F2:F3000<>"External"))