writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 18:
Line 18: − + Line 81:
Line 81: − + − + − + − | class="sshl_f" | <30 + − + − + − +
Manuals/calci/DAVERAGE (view source)
Revision as of 21:27, 11 November 2013
, 21:27, 11 November 2013no edit summary
*The argument 'field' is optional. If not mentioned, the function averages all the values from database that match the criteria.
*The argument 'field' is optional. If not mentioned, the function averages all the values from database that match the criteria.
* A 'column name' in quotes (e.g. "Salary") or 'column number' (e.g. 3, if Salary is 3rd column) can be used as 'field' argument.
* A 'column name' in quotes (e.g. "Price") or 'column number' (e.g. 3, if Price is 3rd column) can be used as 'field' argument.
*Criteria can be any range on the 'Calci' with minimum of one column and at least one row indicating the condition.
*Criteria can be any range on the 'Calci' with minimum of one column and at least one row indicating the condition.
{| id="TABLE2" class="SpreadSheet blue"
{| id="TABLE2" class="SpreadSheet blue"
|- class="even"
|- class="even"
| class="sshl_f" | '''Stationary Items'''
| class="sshl_f" | '''Item'''
| class="sshl_f" | '''Count'''
| class="sshl_f" | '''Quantity'''
| class="sshl_f" | '''Price'''
| class="sshl_f" | '''Price'''
| class="sshl_f" | '''Profit'''
| class="sshl_f" | '''% Profit'''
|- class="odd"
|- class="odd"
| class="sshl_f" | Pen
| class="sshl_f" | Pen
| class="sshl_f" | >10
| class="sshl_f" | >10
| class="sshl_f" |
| class="ssh1_f" |
| class="ssh1_f" |
|- class="even"
|- class="even"
| class="sshl_f" | '''Stationary Items'''
| class="sshl_f" | '''Item'''
| class="sshl_f" | '''Count'''
| class="sshl_f" | '''Quantity'''
| class="sshl_f" | '''Price'''
| class="sshl_f" | '''Price'''
| class="sshl_f" | '''Profit'''
| class="sshl_f" | '''% Profit'''
|- class="odd"
|- class="odd"