why {=product(row(1:10))} gives error?

  • Thread starter Thread starter dindigul
  • Start date Start date
D

dindigul

I have 1-10 in A1:A10 and issue the above formula. Though the result is ok,
I get an error saying the formula refers to empty cells and points to cell
A1. Why is this?
 
Try:

=PRODUCT(A1:A10)


instead. 1:10 means all cells of the first 10 rows.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Show other cell if blank 5
Simple Module for Excel 2007 in VBA 6
function for last non-blank entry in column? 2
Building closed workbook file path within an Index Function 6
How to set cell value to emptry if three other columns are empty too 1
Figuring out a lengthy formula. Probably quite simple... 3
(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O 5

Back
Top