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
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.
Here's a link to this great service
Posted on Jan 02, 2017
Tips for a great answer:
Dec 15, 2017 | PayPal Computers & Internet
Apr 13, 2015 | Computers & Internet
Jan 19, 2013 | Computers & Internet
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
109 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: