“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

I have a pivot table running of a set of call center data table. The pivot tabulates a monthly count of calls per product. I want to insert an additional column to calculate the average of the monthly count of calls and to flag any cell where the average is less than any of the preceding months call count.

Solved by S. H. in 15 mins

Hi, I have a problem trying to summarise the data from a spread sheet I have created. The summery I require is to filter the 'divisions' while being to count the number of 'Yes', 'No' and 'N/A' answers to a given questions Q1, Q2, Q3 etc. I seem to be unable to do this using pivot tables as there is too my variables, is there another way of summarising the data?

Solved by T. B. in 13 mins

Hi, I'm having a problem with a pivot table that wont produce the summery of the data that i require. I need to be able to filter the 'divisions' to provide the number of 'yes', 'no' and 'n/a' to a given question 'Q1', 'Q2' etc. When I have used a pivot table there doesn't appear to be enough options to count the number of text answers. Instead it only counts the number of one of the columns and replicates the data?

Solved by Z. B. in 19 mins

how do i count how many machines that have a rating of 3. Keeping in mind that 3 ratings of 3 in the QCD still warrants as 1. or 2 rating of 3 still warrants as one

Solved by C. L. in 23 mins

Need a formula to count values across multiple cells but only when text is present in a certain cell

Solved by T. C. in 24 mins

I have 24 months of sales data and I want to calculate a order point for the items in my store. I have found out how to calculate order points for items that have data for all 24 months. We add new items regularly and if I use 24 months it contains zero's for months prior to date added. so it will calculate a lower order point because of the zero's. is there a way to count right to left and when I run into the first number return the number of cells that was just counted so I can calculate the average, standard deviation and z score for each item with less than 24 months sales data.

Solved by K. U. in 15 mins

I have a data having coloumns Country, Region, Service Provider, status and
Launch date. I want to prepare data as number of service provider (count) launched by years.

Solved by S. Y. in 30 mins

As you can see from the spreadsheet I have social needs and up to 4 agency referrals made for each social need. Sometimes a referral is made only to one agency or up to 4 referrals. I am trying to create a pivot table and chart to display this. Because there is 4 different columns for agencies I am having a hard time to combine the agency rows with out loosing the social need that is was created for. I am looking to count the agency referrals made for each social need. Hopefully this makes sense. Thank you for your time.

Solved by F. A. in 17 mins

I need to count the number of times a numeric value appears within separate sets of data in a spreadsheet.
We're rating clinical competencies of nursing students on various things in different categories (listed in the rows) over the semester (16 weeks listed in the columns). The ratings are 0 to 4 depending how well they do.
So I need to count the # of 4's, 3's, 2's, 1's & 0's received during the 16 weeks in 8 sets of data Patient Centered Care has 2 rows of data & 16 columns, Professionalism has 8 rows of data & 16 columns, Clinical Judgment has 5 rows of data & 16 columns, and there are 5 more sets of similar data.
Is there a formula that can do this?

Solved by A. A. in 26 mins

I need to figure out how to count specific months and if the month is may to use the data that is in that month column

Solved by O. J. in 26 mins