Results 1 to 6 of 6

Sumproduct

Threaded View

este994 Sumproduct 04-21-2011, 05:32 AM
martindwilson Re: Sumproduct 04-21-2011, 05:37 AM
este994 Re: Sumproduct 04-21-2011, 05:44 AM
daddylonglegs Re: Sumproduct 04-21-2011, 05:50 AM
este994 Re: Sumproduct 04-21-2011, 05:58 AM
martindwilson Re: Sumproduct 04-21-2011, 06:23 AM
  1. #1
    Registered User
    Join Date
    03-30-2011
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    90

    Sumproduct

    Hello.

    I have the following formula:

    =SUMPRODUCT(('Retailer1!$K$2:$K$2263=CONCATENATE(A5,"LY"))*('Retailer1'!$L$2:$L$2263<>0))

    And I want it to give me the number of times the number changes from 0 to a rather than counting all the values higher than 0.

    Can anyone helpme?
    Last edited by este994; 04-21-2011 at 05:43 AM.

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