countblank with sumproduct? - microsoft.public.excel.worksheet.functions

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

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

Similiar Articles:

Count cells matching two criteria (DATE & TEXT) - microsoft ...
Excel Count Functions -- Count Excel Cells Use Excel COUNT, COUNTIF, COUNTA, COUNTBLANK, SUMPRODUCT or SUBTOTAL to count Excel text, numbers, blank cells.

Completing a COUNTBLANK after a COUNTIF Statement in Excel 2007 ...
Hello, I am trying to complete a automated report by completing a COUNTIF on a Spreadsheet to give me the Total, and then complete a COUNTBLANK to give me the missing.

Excel Count Functions -- Count Excel Cells
Use Excel COUNT, COUNTIF, COUNTA, COUNTBLANK, SUMPRODUCT or SUBTOTAL to count Excel text, numbers, blank cells. Match criteria. Count filtered cells

Excel :: Countblank With If Condition
Sumproduct With More Than One Condition Here is my dilemma I have 3 columns with data ranges two of which need to match certain criteria and if the criteria is met ...

CountBlank Method
SumProduct Method ... IWorksheetFunction.CountBlank Method ... This method supports ...

COUNTBLANK function - Excel - Office.com - Microsoft Corporation ...
Syntax: COUNTBLANK(range) ... This article describes the formula syntax and usage of the COUNTBLANK function (function: A prewritten formula that takes a value or ...

7/28/2012 5:45:48 AM