dsum-apples-total |
DSUM |
=DSUM(A1:D5, "Price", F1:F2) |
value |
1 |
dsum-field-by-index |
DSUM |
=DSUM(A1:D5, 4, F1:F2) |
value |
1 |
dsum-comparator-criteria |
DSUM |
=DSUM(A1:D5, "Units", H1:H2) |
value |
1 |
dsum-empty-result |
DSUM |
=DSUM(A1:D5, "Price", F1:F2) |
value |
1 |
dcount-apples |
DCOUNT |
=DCOUNT(A1:D5, "Price", F1:F2) |
value |
1 |
dcount-field-by-index |
DCOUNT |
=DCOUNT(A1:D5, 3, H1:H2) |
value |
1 |
dcount-ignores-text-in-numeric-field |
DCOUNT |
=DCOUNT(A1:D5, "Product", F1:F2) |
value |
1 |
dcount-empty-result |
DCOUNT |
=DCOUNT(A1:D5, "Price", F1:F2) |
value |
1 |
dcounta-apples |
DCOUNTA |
=DCOUNTA(A1:D5, "Product", F1:F2) |
value |
1 |
dcounta-field-by-index |
DCOUNTA |
=DCOUNTA(A1:D5, 1, G1:G2) |
value |
1 |
dcounta-empty-result |
DCOUNTA |
=DCOUNTA(A1:D5, "Product", F1:F2) |
value |
1 |
dget-single-match |
DGET |
=DGET(A1:D5, "Price", F1:G2) |
value |
1 |
dget-field-by-index |
DGET |
=DGET(A1:D5, 4, F1:G2) |
value |
1 |
dget-multiple-matches-error |
DGET |
=DGET(A1:D5, "Price", F1:F2) |
error-code |
2 |
dget-no-match-error |
DGET |
=DGET(A1:D5, "Price", F1:F2) |
error-code |
1 |
dmax-apples |
DMAX |
=DMAX(A1:D5, "Price", F1:F2) |
value |
1 |
dmax-field-by-index |
DMAX |
=DMAX(A1:D5, 4, G1:G2) |
value |
1 |
dmax-comparator-criteria |
DMAX |
=DMAX(A1:D5, "Units", H1:H2) |
value |
1 |
dmin-apples |
DMIN |
=DMIN(A1:D5, "Price", F1:F2) |
value |
1 |
dmin-field-by-index |
DMIN |
=DMIN(A1:D5, 3, G1:G2) |
value |
1 |
dmin-all-rows |
DMIN |
=DMIN(A1:D5, "Units", H1:H2) |
value |
1 |
dproduct-apples-price |
DPRODUCT |
=DPRODUCT(A1:D5, "Price", F1:F2) |
value |
1 |
dproduct-field-by-index |
DPRODUCT |
=DPRODUCT(A1:D5, 4, G1:G2) |
value |
1 |
dproduct-empty-result |
DPRODUCT |
=DPRODUCT(A1:D5, "Price", F1:F2) |
value |
1 |
daverage-apples |
DAVERAGE |
=DAVERAGE(A1:D5, "Price", F1:F2) |
value |
1 |
daverage-field-by-index |
DAVERAGE |
=DAVERAGE(A1:D5, 3, G1:G2) |
value |
1 |
daverage-comparator-criteria |
DAVERAGE |
=DAVERAGE(A1:D5, "Units", H1:H2) |
value |
1 |
dstdev-apples-price |
DSTDEV |
=DSTDEV(A1:D5, "Price", F1:F2) |
value |
|
dstdev-field-by-index |
DSTDEV |
=DSTDEV(A1:D5, 4, F1:F2) |
value |
|
dstdevp-bananas-units |
DSTDEVP |
=DSTDEVP(A1:D5, "Units", F1:F2) |
value |
1 |
dstdevp-apples-price |
DSTDEVP |
=DSTDEVP(A1:D5, 3, F1:F2) |
value |
1 |
dstdevp-field-by-index |
DSTDEVP |
=DSTDEVP(A1:D5, 4, F1:F2) |
value |
1 |
dvar-apples-price |
DVAR |
=DVAR(A1:D5, "Price", F1:F2) |
value |
1 |
dvar-bananas-units |
DVAR |
=DVAR(A1:D5, 4, F1:F2) |
value |
1 |
dvar-field-by-index |
DVAR |
=DVAR(A1:D5, 3, F1:F2) |
value |
1 |
dvarp-apples-price |
DVARP |
=DVARP(A1:D5, "Price", F1:F2) |
value |
1 |
dvarp-bananas-units |
DVARP |
=DVARP(A1:D5, 4, F1:F2) |
value |
1 |
dvarp-field-by-index |
DVARP |
=DVARP(A1:D5, 3, F1:F2) |
value |
1 |