Hi all,

With the help of the sumproduct formula I'm trying to count how many tickets
were created by our Servicedesk team sorted by division of the reporter of
the incident.

In my spreadsheet Column N shows the groups that can create tickets and
column T shows the division of the reporter of the ticket.

I used this formula:

=SUMPRODUCT(('Data SD Opened'!N2:N65536="dlo-NL-HDK*")*('Data SD Opened'!T2:
T65536="*Concernstaf*"))

The result I get is 0 even though there are tickets from the division
Concernstaf.

Can somebody please tell me what's wrong in my formula?

Any help would be greatly appreciated.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200602/1