!range,criteria,average_range!!Finds average(arithmetic mean) for the cells specified by a given condition or criteria!is the range of cells you want evaluated!is the condition or criteria in the form of a number, expression, or text that defines which cells will be used to find the average!are the actual cells to be used to find the average. If omitted, the cells in range are used!
progID,server,topic1,topic2,.!Retrieves real-time data from a program that supports COM automation!is the name of the ProgID ...
R1C1_mode,dde_on,sum_info,tips,recent_files,old_menus,user_info,font_name,font_size,default_location,alternate_location,sheet_num,enable_under ...
range!Counts the number of empty cells in a specified range of cells!is the range from which you want to count the empty ...
range,criteria!Counts the number of cells within a range that meet the given condition!is the range of cells from which you ...
range,criteria,average_range!Finds average(arithmetic mean) for the cells specified by a given condition or criteria!is the ...
range,criteria,sum_range!Adds the cells specified by a given condition or criteria!is the range of cells you want evaluated!is ...
rate,nper,pmt,fv,type!Returns the present value of an investment: the total amount that a series of future payments is worth ...
rate,nper,pmt,pv,type!Returns the future value of an investment based on periodic, constant payments and a constant interest ...
rate,nper,pv,fv,type!Calculates the payment for a loan based on constant payments and a constant interest rate!is the interest ...