!range,criteria!!Counts the number of cells within a range that meet the given condition!is the range of cells from which you want to count nonblank cells!is the condition in the form of a number, expression, or text that defines which cells will be counted!
progID,server,topic1,topic2,.!Retrieves real-time data from a program that supports COM automation!is the name of the ProgID ...
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 ...