Question about Microsoft Excel for PC

# Excel farmulas how can be multiplied two column data according to one column data reference.Details is being written below. A1:A7000 (0101,0201,0301,0101,0504,0201) this is cat B1:B7000 (199,299,199,299,399,499,299,199) this is price point C1:C7000( 88,55,1000,23,65,56,80,70,40) this is sold qty Here i want to multiply B*C according to cat wise but from farmulas only . Please provide me formulas. 0101 ? 0201 ?

Posted by on

• Level 1:

An expert who has achieved level 1.

• Contributor

use the function dproduct(),the arguments that this function takes are
the data base for e.g is this

colA

colB

colC
0101 199 88 0201 299 55 0301 199 1000 0101 299 23 0504 399 65 0201 499 56 0301 299 80 0504 199 70 0201 299 40
the criteria range is this

cloA cloB colC
0101

formula will be.
=DPRODUCT(A1:C10,B1,D1:D2)*DPRODUCT(A1:C10,C1,D1:D2)

bye
Farrukh.

Posted on Feb 20, 2009

• Level 1:

An expert who has achieved level 1.

Corporal:

An expert that hasĀ over 10 points.

Mayor:

An expert whose answer gotĀ voted for 2 times.

Problem Solver:

An expert who has answered 5 questions.

• Contributor

Add another colum, say D with result of B*C

Do a list of the different cat, and use sumif
For cat 0101 (in cell F1)
formula to put in G1
=sumif(\$A\$1:\$A\$7000;F1;\$D\$1:\$D\$7000) where F1 contain 0101

expand the formula for other cat. (G2, G3, etc)

You can use a assistant to extract the distinct cat from A1:A7000, sorting them and copy the result in F (Menu Data-> Filter -> elaborate filter)

Posted on Feb 18, 2009

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
goodluck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### What are the formulas in grading the grades uisng microsoft excel

Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.

Formulas used in Excel must follow a certain syntax.

1. All formulas begin with an equals sign (=).
2. Some formulas use operands such as +,-, *,/ for addition, subtraction, multiplication or division.
For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3.
3. Other formulas refer to different functions such as SUM, AVERAGE and others.
For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3.
4. Formulas can be combined with operands.
For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10.
5. Functions can be nested within each other.
For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.

Aug 19, 2011 | Microsoft EXCEL 2004 for Mac

### How i use underroot inexel farmula

Hey!

I'm not sure what do you mean by "underroot", but if it's the square root that you need, the formula is as follows:
=SQRT(A1)

and also:
=A1^(1/2) - the square root
=A1^(1/3) - the cube root
etc...

Regards,
Pelu.

Feb 09, 2011 | Business Industrial Network Free MS Excel...

### Excel formulas

{=max(if(category column = category in query, price data column))}

Nov 18, 2008 | Microsoft Excel for PC

### Excel formula

I'm assuming you'd like to assign a numerical value to cardinal references (1st, 2nd, 3rd, 4th, etc.).

Best way to do this is to create a quick lookup table on a separate sheet of the same .xls document. Down at the bottom of the page, click on Sheet2 and create a quick table where column A has 1st, 2nd, 3rd, etc. and column B has your values.

Now click back to Sheet1 where your data is and in A2 put this formula:
=VLookup(A1, Sheet2!\$A\$1:\$B\$x, 2, FALSE)
Note: replace the lower case x in the formula above with the number of the last row of data in your lookup table on Sheet2.

You can copy and paste this formula down the column to calculate your other values.

Hope that helps!
Terry

Aug 30, 2008 | Microsoft Excel for PC

### Computer

Any formula in Excel starts with the equals sign ("="). This is how Excel distinguishes between formulas and literal values. Knowing this, you can create lots of formulas using the usual operators of +, -, * and / for addition, subtraction, multiplication and division, respectively. Please see the examples below.

Add the contents of cell A1 to the contents of cell B1: =A1+B1

Subtract 2 - 1: =2-1
Add the contents of cell A1 from the contents of cell B1: =B1-A1

Multiply 1 times 2: =1*2
Multiply the contents of cell A1 times the contents of cell B1: =A1*B1

I hope this resolves the question. If not, please let me know.

Aug 08, 2008 | Microsoft Computers & Internet

### How do i make subtraction, additions and divisions using excell

Put the figure which you have to multiply in cell A1, Put the figure in cell A2 by which you have to multiply by, type =A1*A2 in cell A3. You will get the right answer.
You may substract, multiply or add by this method by appropriate mark in cell A3 in between A1 and A2.

npbhoge@rediff.com

Jul 29, 2008 | Microsoft Excel for PC

### Formula required

at first select the 1st page data and select data-subtotal from the upper menu list.
then enter the formula as =sum(1stpageSubTotal,2ndpageSubTotal,3rdpageSubTotal) then Press Enter.

If not solved pls get me that data as to reference.

thanks

Dec 04, 2007 | Microsoft Excel for PC

## Open Questions:

#### Related Topics:

156 people viewed this question

Level 3 Expert

Level 3 Expert