Multiplying 2 columns

  • Thread starter Thread starter Shindy
  • Start date Start date
S

Shindy

How do I mulitiply one column with another column to get
the total. What I'm trying to do is multiply an
employee's rate of pay times their vacation balance, this
will give me the accrued amount for leave liability. I
can do it one by one for each employee but that would take
forever. Thanks in advance!
 
Hi Shindy,

You can enter the folrmula in the first step and drag it to all th
other cells in the coloumn.

Try the following stpes

1.Enter the formula "=A1*B1" in the cell C1 where A1=employee rate o
pay times and B1=their vacation balance

2.select Cell C1, place your cursor at the bottom right corner of th
cell till it turns into a "+" sign.

3.Click and Drag the cursor to all the remaining cells

**Note under TOOLS->OPTIONS->Calulation tab make sure you have a chec
against "Automatic"**

Sailes
 
Shindy,

If you don't care what the answer is by employee, you
could try this solution:

=SUMPRODUCT(B1:B400*C1:C400) assuming columns B and C
contain your rates and hours by employee.

This would give you the answer in one cell without having
to figure it individually.

Eric
 
Back
Top