Thread: Problems with SUMPRODUCT function

I have a spreadsheet with three columns. The first column is a site ID, the second is software version ID, and the third column is Engineer name.

There are 150 sites listed
There are a five different software versions listed in the software version ID column.
There are 4 engineers who have each been assigned to an equal number of sites.

The software version will be updated in the spreadsheet
I wish to count the total number of software upgrades carried out by each engineer.
I wish to count two Software version ID types "2.02.00" and '2.02.01".

I have tried using the "SUMPRODUCT" function. However, I am only able to get this to work with one software version ID. I need to count two software IDs.
I tried to use wildcard characters but these do not seem to be supported by the SUMPRODUCT function.

try combining the sumproduct conditions for the versions with a + sign. Version ID in column A, engineer in column B:

=sumproduct((A1:A100="2.02.00")+(A1:A100="2.02.01"),--(B1:B100="Joe Bloggs"))

hth