!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 !
Queries are used to import external data into Excel, but harmful queries can be used to access confidential information or ...
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 ...