Question about Computers & Internet
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:
Dec 15, 2017 | PayPal Computers & Internet
Oct 23, 2017 | The Computers & Internet
Aug 26, 2017 | The Computers & Internet
Mar 23, 2017 | Computers & Internet
Dec 22, 2016 | Washing Machines
Sep 29, 2016 | The Watches
Sep 26, 2016 | Amazon Computers & Internet
Aug 11, 2016 | Computers & Internet
Nov 20, 2013 | Computers & Internet
39 people viewed this question
Usually answered in minutes!