On Jul 29, 1:33*pm, Brad wrote:
Alright now I get it,

The equation that I gave you will not work for your column B, because it is
inserting a zero for a blank (because of the equation that you are using)
just as you were stating. * I was understanding that you hadblanks(not
equations looking atblanks). What you did, by using the if statement, will
work for column B *

However, the product forumla will work for your column A (and you can
reference sheet1 very easily....) *Hope the rest of your day goes better!!

Hope this helps!
--
Wag more, bark less



"K-Man" wrote:
On Jul 29, 12:05 pm, Brad wrote:
Change the format on the cell that has the product formula to "General" with
10 decimal places - do you still get a zero?

--
Wag more, bark less

"K-Man" wrote:
On Jul 29, 11:26 am, Brad wrote:
Taken directly from microsoft help

=PRODUCT(number1, [number2], ...)
Show All
Hide All
This article describes the formula syntax and usage of the PRODUCT function
(function: A prewritten formula that takes a value or values, performs an
operation, and returns a value or values. Use functions to simplify and
shorten formulas on a worksheet, especially those that perform lengthy or
complexcalculations.) in Microsoft OfficeExcel.

Description
The PRODUCT function multiplies all the numbers given as arguments and
returns the product. For example, if cells A1 and A2 contain numbers, you can
use the formula =PRODUCT(A1, A2) to multiply those two numbers together.. You
can also perform the same operation by using the multiply (*) mathematical
operator; for example, =A1 * A2.

The PRODUCT function is useful when you need to multiply many cells
together. For example, the formula =PRODUCT(A1:A3, C1:C3) is equivalent to
=A1 * A2 * A3 * C1 * C2 * C3.

Syntax
PRODUCT(number1, [number2], ...)The PRODUCT function syntax has the
following arguments (argument: A value that provides information to an
action, an event, a method, a property, a function, or a procedure.):

number1 *Required. The first number or range (range: Two or more cells on a
sheet. The cells in a range can be adjacent or nonadjacent.) that you want to
multiply.
number2, ... *Optional. Additional numbers or ranges that you want to
multiply, up to a maximum of 255 arguments.

*Note * If an argument is an array or reference, only numbers in the array
or reference are multiplied. Empty cells, logical values, and text in the
array or reference are ignored

--
Wag more, bark less

"K-Man" wrote:
Hello Brad,

This formula also gives me 0 ifblanksare included.

thanks

On Jul 29, 10:56 am, Brad wrote:
=product(a1:a10). *this will ignoreblanks
--
Wag more, bark less

"K-Man" wrote:
Hi,

Thanks for the info...I know all this..

my worksheet formula is giving me zero for all the calcuated cells
which I have not data for, so that's why I am getting zero when I try
to multiply all the blank cells.

I am doing calcuations mainly multiplications of multiple cells, for
e.g =a1*a2*a3...a10. *Cells a1-a5 has some number in it however a6-a10
Yes,

The problem is that mycalculationsin blank cells which have no data
in it defaults to zero so when I referece those cells when doing my
calculation it gives me zero, anything multiplied by 0 is 0 I guess..

Here's my worksheet:
B2
=sheet1!A1 (which is 94)
B3
=Sheet1!A2 (which is blank, data to be entered in future)
B4
=Sheet1!A3 (which is blank, data to be entered in future)
B5
=Sheet1!A4 (which is blank, data to be entered in future)
B6
=product(B2:B5) (it willgive you blank or zero depending if you have
the checkmark set to options view tab)

The answer I am looking for is 94, for B6 however it will update once
I input data in B3, B4 etc..it should not give me zero or blank.

try this out..

Thanks

does not. *However it gives me result of 0 if blank cells are also
included in the calculation.
Anyways..thanks very much for your assitance..


How do I go about calculating so that the blank cells are ignored
unless it *has any number in it.

thanks in advance..- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -