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

want a count of student having marks between 50 and 70

Solved by A. C. in 26 mins

I'm trying to figure out a formula that lets me find the 3rd character of a number within a certain date range and then take the total count and divide it by the total piece count to give me a % which reflects onto another sheet in that workbook. The formula I am using to find the 3rd character is =SUMPRODUCT(--(MID(I18:I500,3,1)="9")) and =SUMPRODUCT(--(MID(I18:I499,3,1)="8")). Here are some pictures that might help. I need the 3rd character in column "I" to be totaled and then divided by the total piece count "B4" to get a percentage that is reflected on Sheet "PDC Dashboard" in B57, C57, etc based on the date range those pieces are in.

Solved by A. A. in 21 mins

Hello, the SUM is not working in the Sort by Valor in Pivot Table. Sort by COUNT() excel works but, if you look at the attachment you will see that sum is a fake. I have checked everything and I really don't understand why is making like this

Solved by X. A. in 13 mins

Im trying to make a formula stating if a cell within A:A equals a date in january AND if a cell in column E:E equals "X" ,count.

Solved by S. J. in 11 mins

I have a spreadsheet which contains 5 columns. Names, Date of enrollment , Case Manager, Location and Hourly Income rate.
Currently, I have to manually count the days they've been
enrolled, but I NEED the spear sheet to auto populate how many day each client has been enrolled. Can you help me with that?

Solved by B. U. in 14 mins

I am trying to get a column of percentage (GRADES) using the COUNTIF function to excel count cells with value or text, then SUM only those cells. Here's the formula I have so far, but it is not working; =COUNTIFS(C8:C41,"<>"&"",F8:F41,"AVERAGE")

Solved by M. E. in 30 mins

I am trying to use the COUNTIFS formula (not using VBA/Macro) to populate data into a summary dashboard. I have a list of store numbers and a list of data for each store. I need to provide a count of each store number's "Leads" created during the previous week. The formula I have tried to use looks like this:
=COUNTIFS(Data!B:B,"='Leads & Sales '!D8",Data!C:C,">='Weeks FY 2017'!$B$3",Data!C:C,"<='Weeks FY 2017'!$D$3")
Can you please fix the formula above so that it works?
I also need to count the number of "Wins" (Data tab Status of 10 or 11) for each store number during the previous week which I have been unable to create a working formula for. Can you please create a working formula that can be used for this?

Solved by B. U. in 18 mins

Hello
I'm trying to create inventory file based on location we have in our warehouse. From this I wanted to have a formula or something that could generate random locations to count from the data provided.

Solved by K. E. in 16 mins

I need it to count form 164200 to 164800 with out putting it manually.

Solved by B. A. in 28 mins

I am trying to match different rows together and receive a count of how many match the criteria with row I. Basically for row Y i want to count how many instances are both nfp for rows I and K. Another problem is how would I do it so it would give me a count for how many are nfp in row I and fp in row K. I am doing this multiple times for each value of c.

Solved by V. A. in 23 mins