Mathematical summation (Sigma):
=SUMPRODUCT(ROW(INDIRECT(A1&":"&B1) * 4 - 11)) //equals to sum y = x*4-11 from x = A1 to B1
Choose a in b:
=COMBIN(b, a)
Weighted sum:
Mathematical summation (Sigma):
=SUMPRODUCT(ROW(INDIRECT(A1&":"&B1) * 4 - 11)) //equals to sum y = x*4-11 from x = A1 to B1
Choose a in b:
=COMBIN(b, a)
Weighted sum:
<!DOCTYPE html> | |
<html> | |
<head> | |
<title></title> | |
<meta charset="utf-8"/> | |
<link type="text/css" rel="stylesheet" href="https://code.jquery.com/ui/1.11.4/themes/black-tie/jquery-ui.css" /> | |
</head> | |
<body> | |
<script type="text/javascript" src="https://code.jquery.com/jquery-1.12.0.min.js"></script> |
SELECT | |
t.NAME AS TableName, | |
s.Name AS SchemaName, | |
p.rows AS RowCounts, | |
SUM(a.total_pages) * 8 AS TotalSpaceKB, | |
SUM(a.used_pages) * 8 AS UsedSpaceKB, | |
(SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS UnusedSpaceKB | |
FROM | |
sys.tables t | |
INNER JOIN |