SOMPRODUCT

J

Jaydubs

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 !!
 
J

Jaydubs

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


Toppers said:
Try

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

HTH

Jaydubs said:
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 !!
Click to expand...
Click to expand...
 
Top