Multiply many cells by each other

Hello, i hope someone can answer this... i have many many cells that i want to multiply by each other.. i have values for A1, A2, A3, A4...etc...up to A100 and i want to multiply all of them by each other.

manually, i have to enter the formula = A1 * A2 * A3 * A4 etc...up to *A100...

There must be a faster way to do this.

can anyone help me? thanks!

try using the following


=PRODUCT(A1:A1000)

Damn Steve !!! Right on the money!

i appreciate your help ...that was fast.

thank you fellow Montrealer. Merci beaucoup.

Any time..