Results 1 to 20 of 26

Thread: Is this a job for SUMPRODUCT? Or is it easier?

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 09-23-2009, 11:05 AM #8
    Bob Phillips
    Bob Phillips is offline
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,446
    Location
    I am not sure what you mean by it just has one argument.

    It has 3 conditions

    (ISNUMBER(Y!$1:$3)) - only include numeric values in rows 1:3, i.e. not blanks

    (Y!$1:$3<=Z!A1) - only include values in rows 1:3 <= A1 on Z

    (X!$B$1:$B$3="T") - only include rows where the corresponding value in column B of X is a T

    The three conditions are ANDed (*), to give an array of 1s and 0s which are summed.
    Last edited by Bob Phillips; 09-23-2009 at 11:22 AM.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules