Understanding formula '=SUM(('Defects Past SLA'!D3:D12="1 - Severe")*('Defects Past SLA'!P3:P12="One"))'

Understanding this formula: This formula is trying to count the number of cells with "1- Severe' and
"One" values.

=SUM(('Defects Past SLA'!D3:D12="1 - Severe")*('Defects Past SLA'!P3:P12="One"))

The above formula does not work if it is directly directly into a cell.

 

so here the formula needs to be entered with: CTRL+SHIFT+ENTER. This will allow to accept the range as an array for SUM Function.

 

As per the MSDN: http://support.microsoft.com/kb/214153

 

How to Count the Occurrences of a Number

Method 1

Use this formula

=SUM(IF(range=number,1,0))

where range is the range that you want to search, and number is the number that you want to count.

NOTE: This formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER.

When you invoke the SUM function in this way, you have to "array enter" it (since it is using arrays and is by nature, not an array function). To array enter it, hold Ctrl+Shift and then press Enter after typing in the formula.

Method 2

Use the COUNTIF() function to count the occurrences of a text string. For example, use the formula

=COUNTIF(range, Number)

 

I posted this question in Stackoverflow.com, here is link for the responses i got. http://stackoverflow.com/questions/22653362/could-you-please-help-me-understand-the-excel-formula

Err: Activex component cannot create object

Hi, when i am trying to create object that is used to connect QC using vbscript.

I am getting err: Activex component cannot create object.

Extracting Release module structure from QC and displaying it

Extracting Requirements folder structure from QC and displaying it in similar fashion

Creating tree structure in excel userform using vbscript