Question about Miscellaneous
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
SOURCE: Count number of Delivery Status
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
Tips for a great answer:
Nov 29, 2016 | Amazon Computers & Internet
Jul 02, 2016 | Motorcycles
Apr 13, 2015 | Computers & Internet
May 31, 2011 | Toshiba Computers & Internet
May 12, 2011 | Cell Phones
Dec 15, 2010 | Yahoo Mail
Oct 27, 2010 | Amazon Computers & Internet
Jun 18, 2009 | Microsoft Excel for PC
May 29, 2008 | RCA D61W20 61" Rear Projection Television
13 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: