Question about Microsoft Excel for PC

1 Answer

Count number of Delivery Status

TYPE ORDER STATUS HARDWARE DELIVERED HARDWARE Pending Delivery
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

Posted by on

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

    Scholar:

    An expert who has written 20 answers of more than 400 characters.

  • Expert
  • 68 Answers

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

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
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.
goodluck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Trying to find out if order has been shipped and delivery status of package


Every website is having its own protocols through which they can able to know about the orders and shipping delivery. In most of the websites we can able to know about order details and shipping delivery from the email id you have given at the time of registration. Some websites are having a page of Order status, from where we can know about the delivery status of your order.

Know More:- Build Your Online Store

Apr 13, 2015 | Computers & Internet

1 Answer

Juscar taxi cebu


Kanina po sumakay ako Around 2-3pm naiwan ko ho ang Phone ko sira naman po yung phone ko but may mga imporatnteng bagay at mga number po akong pinakaiingatan dun
kaya po Please lng san po maisauli yungPhone Ko
kanina po nag usap na po kmi sabi po ey ibabalik nya daw po may ihahatid lng daw po sya papuntang Airport around 4 pm
kaya im still hoping po na mabalik po ang phone ko kahit po mag punta po ako jan sa office nyo po at tignan po every Driver na magreremit i will do it po kilala ko naman po sa mukha yung Driver ey
please give me the location and contact number
ito po yung number ng phone ko
09435641043 na naiwan ko po sa Taxi

Jan 19, 2013 | Computers & Internet

1 Answer

I need a postal zip code for the following address: P.O. Box 760, Accra Ghana, Ghana-West Africa


There is no Zip Codes in Accra, Ghana, West Africa.
Because there is no home delivery of letters or parcels; most people have post office boxes. An address would be something like this:
P.O. Box 4573 AN Means post office box number Accra-North Means actual post office location Accra, Ghana City and Country
Hope that helps.

Sep 19, 2011 | Computers & Internet

1 Answer

I topped up my phone yesterday now messages are pending and not sent


Here is what we have.

If you turned on 'delivery reports', and the status show 'message sent', when you send them, but it shows 'pending' upon awaiting delivery report, then the problem is either that the number you sent the message to is unavailable, or there is a network problem.
Try dialing the numbers. If they go through, then it is a network problem.
Contact your mobile service operators and let them know what is going on.
But if the numbers dont go through, then they are probably unavailable to receive the sms.

If your 'delivery reports' is 'off', then you would have to check that your message centre number is in order. If you are not certain of the number, confirm it with another phone of the same network as yours.
You can get your message centre number through;
messages> message settings> sending profile> (select the profile in use)> message centre number.

Hope that helped.
Success.

May 12, 2011 | Cell Phones

1 Answer

Hello have not received goods its supposed to bea next day delivery


There are several reasons that an order gets delayed. If you placed the order late at night, there's a big chance that order did not meet the cut-off time so it will be processed the next day. However, if you are confident that you placed it just on time, you need to check now by logging in to your account and click "Your account" then choose your order to view its status. A tracking number should be there if it shipped out if not, an appropriate order status will be displayed.

If you have the tracking number you can check directly with the carrier to get details of delivery.

Oct 27, 2010 | Amazon Computers & Internet

1 Answer

I'd like to avail of the word count tool but i don't know how.


I am not very sure about what program you would like to avail the word count, but if you mean microsoft word (office 2007), follow the instructions below:
Open the Microsoft Word, > (1.) Right-click on the status bar, >(2.) Select "Word Count", now you'll be able to see the number of words on the (3.) status bars as shown below (labelled 1, 2 and 3)
7f0f40a.jpg

If you need further help, please let me know with more details.

Good luck.

Thanks for using FixYa.

Aug 22, 2010 | Microsoft Office Professional 2007 Full...

2 Answers

Count the number of open and closed order status per owner


My suggestion is to use a Pivot Table.  Follow these instructions:
Click on column A1 - then in the menu bar click DATA > Pivot Table and Pivot Chart Report.  

Click NEXT on step 1 of pivot table wizard.
For step two you will want to highlight all of the data on your sheet.  then click next.
Choose NEW WORKSHEET for step 3 of the pivot table wizard and click finish.
Once the Pivot Table sheet opens, drag the STATUS field into the top left corner of the pivot table view, where "drop column fields" and "drop row fields" meet.  Next drop another instance of the STATUS field into the "drop row fields here" column.  And lastly drop the OWNER field into the "drop column fields here" section.  You should now be viewing a report showing you exactly what you were looking for.
Regards,
Joe


May 07, 2009 | Microsoft Excel for PC

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

94 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2775 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18394 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...