SOMPRODUCT

[Guest]

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'!D365534)="")
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 !!

 

[Guest]

Try

=SOMPRODUCT(--('Data entry'!K3:K65534="Ja");--(('Data entry'!D365534=""))

HTH

 

[Guest]

Perfect, thanks !!
--
** Fool on the hill **

Try

=SOMPRODUCT(--('Data entry'!K3:K65534="Ja");--(('Data entry'!D365534=""))

HTH

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'!D365534)="")
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 !!