Dear Excel(lent ) users,
I am trying to see how many incidents from a certain type are open. To do
this you have to look in two columns to retrieve that information. I tried
this with SOMPRODUCT (SUMPRODUCT in English).
I tried
=SOMPRODUCT(--('Data entry'!K3:K65534)="Ja");--(('Data entry'!D3:D65534)="")
But that did not work.
Column K has the types of the incidents (either 'Ja' [yes] or 'Nee' [no]).
In column D dates are filled in if the incident are closed. If it is open
there is no date.
I hope this makes sense 2 u, if not feel free to ask me !!
Thanks very much !!
--
** Fool on the hill **
Bookmarks