Prev: Conditional formula yeilds nonnumber result
Next: Conditional formula with text and number in cell
From: Rene on 29 May 2010 14:23 Hi, SUMPRODUCT((S3:S44="A"),(E3:M44>100),(E3:M44<=200))/SUMPRODUCT((S3:S44="A"),(E3:M44<>"")) doesn't work unless it is E3:E44 Looking to modify the formula to include rows with text in s3:s44 in addition to the "A" Also, looking for a formula that will compute the percentage of e3:m44 when s3:s44 is blank. Thanks for your help. Cheers
From: Brad on 29 May 2010 21:21 Your vector dimensions aren't the same s3:s44 is a 1x42 and E3:m44 is a 9x42 you need to have the vector being the same dimensions.  Wag more, bark less "Rene" wrote: > Hi, > > SUMPRODUCT((S3:S44="A"),(E3:M44>100),(E3:M44<=200))/SUMPRODUCT((S3:S44="A"),(E3:M44<>"")) doesn't work unless it is E3:E44 > > Looking to modify the formula to include rows with text in s3:s44 in > addition to the "A" > > > Also, looking for a formula that will compute the percentage of e3:m44 when > s3:s44 is blank. > > Thanks for your help. > Cheers

Pages: 1 Prev: Conditional formula yeilds nonnumber result Next: Conditional formula with text and number in cell 