+ Reply to Thread
Results 1 to 3 of 3

[solved] somproduct

  1. #1
    Jaydubs
    Guest

    [solved] 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. #2
    Toppers
    Guest

    RE: 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. #3
    Jaydubs
    Guest

    RE: 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1