Google Sheets PRODUCT function returns the result of multiplying a series of numbers together. The product function accepts number values, cell references, arrays, and constants, in any combination.
PRODUCT FunctionPurpose
Multiply the values of the specified cells, numbers, ranges, or any combination.
PRODUCTSyntax
Elements of the function
=PRODUCT(factor1,[factor2,...])
Function Name.
factor1 – [Required] The first number, range, or cell to be multiplied.
factor2,… – [Optional] Additional numbers, ranges, or cells to be summed.
Arguments of the function
The PRODUCT function will multiply all numerical values specified.
Samples of the Product function
=PRODUCT(1,2,3,4)
=PRODUCT(A1:B100)
=PRODUCT(1,2,A1:A3)
PRODUCT Notes
PRODUCT will ignore cells containing text.
Google Sheets PRODUCT function is specified as taking a maximum of 30 arguments, Google Sheets supports an arbitrary amount. Performance becomes an issue, but we have put this limit to the test and have exceeded 10,000 arguments before. A more common limiting factor is “Your input contains more than the maximum of 50,000 characters in a single cell.”
If only factor1 is specified in the function, PRODUCT will return factor1.
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional
Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
var complianz = {"prefix":"cmplz_","user_banner_id":"1","set_cookies":[],"block_ajax_content":"","banner_version":"31","version":"7.4.4","store_consent":"","do_not_track_enabled":"","consenttype":"optout","region":"us","geoip":"","dismiss_timeout":"","disable_cookiebanner":"","soft_cookiewall":"","dismiss_on_scroll":"1","cookie_expiry":"365","url":"https:\/\/simplifysheets.com\/wp-json\/complianz\/v1\/","locale":"lang=en&locale=en_US","set_cookies_on_root":"","cookie_domain":"","current_policy_id":"28","cookie_path":"\/","categories":{"statistics":"statistics","marketing":"marketing"},"tcf_active":"","placeholdertext":"Click to accept {category} cookies and enable this content","css_file":"https:\/\/simplifysheets.com\/wp-content\/uploads\/complianz\/css\/banner-{banner_id}-{type}.css?v=31","page_links":{"us":{"cookie-statement":{"title":"","url":"https:\/\/simplifysheets.com\/blog\/formulas\/split-names-google-sheets"},"privacy-statement":{"title":"Privacy Policy","url":"https:\/\/simplifysheets.com\/privacy-policy"}}},"tm_categories":"1","forceEnableStats":"","preview":"","clean_cookies":"","aria_label":"Click to accept {category} cookies and enable this content"};
