Question about Microsoft Excel for PC
HARDWARE DELIVERED SERVICE Pending PO LICENSE DELIVERED HARDWARE DELIVERED HARDWARE Pending Quotation HARDWARE Pending Delivery
I need to count the number of order.
Result in this:
Order Status Counter Delivered Pending Delivery Status Pending Delivery Pending PO Pending Quotation
To count textual values, use the countif function; the syntax is =countif(range,criteria). So, if your range, for example is B3 through B100 and you want to know how many cells contain the status value Delivered, put the following in the cell you want the count to show: =countif(b3:b100, "Delivered"). Do the same thing for each of your other status values in the cell that you want the count to appear.
Note that this requires each status value to be spelled correctly in each cell. I'd recommend assigning shorter values, say 1 through 5 or A through E to avoid that -- unless the values are being generated automatically so the spelling is guaranteed correct.
Posted on Jun 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:
Apr 13, 2015 | Computers & Internet
Jan 19, 2013 | Computers & Internet
Oct 31, 2012 | Cell Phones
Jul 24, 2012 | Cell Phones
Sep 19, 2011 | Computers & Internet
May 12, 2011 | Cell Phones
Oct 27, 2010 | Amazon Computers & Internet
Aug 22, 2010 | Microsoft Office Professional 2007 Full...
Sep 23, 2009 | Intuit QuickBooks Pro Edition 2009 Full...
May 07, 2009 | 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
94 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: