Total count of radios in for repair (challenge)

**israelalvarado** · 03-01-2017, 02:28 PM

Hello,

so I am hooked on excel again, I have this scenario. I have a master worksheet with multiple customers and entries. what I would like to do is add the count of the radios that are in for repair just for that customer in another worksheet. for instance under "'master log" "C8" to "C10" are all under customer they show belonging to customer "AAR/LAX" because they show that on column "A". how can I show that count of repair radios on "COUNT BY CUSTOMER" worksheet "D14"

is this even possible?.

My goal is to be able to show the total count of radios that are in for repair,
and if possible how many radios were shipped for repair somewhere else.

IF ANYONE HAS ANY IDEAS AS TO HOW TO PRESENT THIS DATA.. I WILL LOVE TO HEAR THEM... MAYBE PIVOT TABLES???.

**AliGW** · 03-01-2017, 02:42 PM

Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution is also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

**JohnTopley** · 03-01-2017, 02:42 PM

Look at COUNTIF / COUNTIFS functions.

**israelalvarado** · 03-01-2017, 04:14 PM

here is the attachment, I am sorry, I thought I had done it.

regards

**israelalvarado** · 03-01-2017, 04:19 PM

hello,

are you able to see it?. i am not sure if this is done correctly?

**israelalvarado** · 03-01-2017, 05:56 PM

hello,

thanks for your help, I do have another problem with this worksheet. will it be ok if I present it to you?. I do not know how to direct message you. this is the only way I know.

Total count of radios in for repair (challenge)

LinkBack

Thread Tools

Rate This Thread

Display

Total count of radios in for repair (challenge)

Re: Total count of radios in for repair (challenge)

Re: Total count of radios in for repair (challenge)

Re: Total count of radios in for repair (challenge)

Re: Total count of radios in for repair (challenge)

Re: Total count of radios in for repair (challenge)

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Formula to count repair parts based on multiple row critierias

Count total people within a group of ranges | Sum total value for ranges and list average

[SOLVED] Here is a Challenge for the Pros!? Wrong %Total in Pivot, any clever idea?

Challenge for everyone - Sort a text list adding a count in the bottom of each group. :)

[SOLVED] count occupied cells, but put count total in different worksheet

Another Count Challenge

[SOLVED] How do i count numbers and letters to find a total count of all

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions