SUMPRODUCT

SUMPRODUCT(array1,array2[,array3,...]) Multiplies the corresponding elements in the specified

arrays and then sums the resulting products

e.g.

dd	bb	Cc
1	1	1
0	2	2
3	5	3
4	8	4
5	5	5
6	6	6
7	7	7
8	8	8
9	9	9
0	10	10

Let’s say we have three ranges dd, bb, cc as shown above in table.

Let say we have following formula

=SUMPRODUCT(--(dd=bb),--(cc))

Let’s walk through row by row

Row 1

=SUMPRODUCT(--(1=1),--(1)) : (1=1) Equals (=) will return 1

=SUMPRODUCT(--(1),--(1)) : 1*1 = 1

Row 2

=SUMPRODUCT(--(0=2),--(1)) : (0=2) Equals (=) will return 0

=SUMPRODUCT(--(0),--(2)) : 0*2 = 0

And so on …

more store mahadevpura

In case you need the address

Bengaluru
Address : Survey # 14, Mahadevpura Outer Ring Road, Near Shiva Ganga Layout, Bengaluru East, Bengaluru – 560048.
Tel : (080) 67611601
Open : 08:30 am to 10:00 pm - 7 days a week

OCS installation

I have started working on OCS installation. I will keep posting errors and other problem faced by me.

While installing ocs on windows 2008, I was getting strange error.

This was happening when i was adding forntend server to the pool.It was asking for windows media formats which are bundled with the ocs setup. when i tried running wmfdist64.exe under AMD64 folder. i was getting follwoing error
"Not Enough storage is available to process this command"

Strange enough when i installed the Desktop Experience feature which install the windows media player fixed this problem.

sipdetails

User Identity: rajendersaini
Alias: 96110
Domain: opensips.org