Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ** |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ** |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|