SOMPRODUCT
 

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 **

SOMPRODUCT
 

Try

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

HTH

"Jaydubs" wrote:

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 **

SOMPRODUCT
 

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


"Toppers" wrote:

Try

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

HTH

"Jaydubs" wrote:

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 **