Question about Microsoft Excel for PC
use the function dproduct(),the arguments that this function takes are
the data base for e.g is this
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
formula will be.
Posted on Feb 20, 2009
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
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)
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
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.
Aug 19, 2011 | Microsoft EXCEL 2004 for Mac
Feb 09, 2011 | Business Industrial Network Free MS Excel...
Sep 06, 2009 | Microsoft Office Professional 2007 Full...
Mar 11, 2009 | Microsoft Office Excel 2003 for PC
Aug 30, 2008 | Microsoft Excel for PC
Aug 08, 2008 | Microsoft Computers & Internet
Jul 29, 2008 | Microsoft Excel for PC
Dec 04, 2007 | Microsoft Excel for PC
Jan 28, 2016 | Microsoft Excel for PC
Dec 12, 2013 | Microsoft Excel for PC
Jul 23, 2013 | Microsoft Excel for PC
157 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: