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

Hi, I have had sessions previously regarding this complex formula. By the time I explain my time is up and I can't seem to get a resolution. Can you help?
I want a formula that counts the number of "names" that are returned in the [formula's answers] but it has to exclude duplicate names & only count each unique name as 1. *Formulas are on Open to Buy TAB and source data is on Style Status TAB.
*yellow highlights are relevant to this Q
explain: Column E - totals the units in [column M-W/H qty] of [column D - 02JAC] - this is correct - and gives me the total stock for 02JAC in W/H.
Then in Column F - what I need is the number to "count as 1" each unique "name keys" in column C - without counting the duplicates - so only count 1 for each unique name key that is 02JAC and has a qty in W/H Qty field.
{I have filtered source data & have highlighted yellow the unique name keys that should be counted in the formula to give result = 86 in column F]
*I also need a similar count formula added to the formula in Column L - this is more complex - as formula already there is correct - I just need it again to only "count unique name keys in column C - as 1 without counting the duplicate namekeys] the result should = 3 in this column L for line 02JAC
*hopefully have time..
Note: source data has been filtered to only show result of column F.

Solved by G. C. in 16 mins

I need to count unique, non-numeric values from a dynamic column.

Solved by D. L. in 23 mins

Hi, I am looking for a formula that will count as 1 the number of names returned in the answer - but will not count duplicate names - only unique names.
Formula is in Column F - Open to Buy Tab - and the answer should = 86
Formula Column F - Count as 1 each unique "name keys" in column C - if column D [Cat], = A8 [Cat], and if column M has a Qty.
Source data is on Style Status Report TAB. I have highlighted yellow the name keys that = the answer for column F.
A similar formula is also required in Column L - this answer should = 3
Formula Column L - Count as 1 each unique "namekey" in Column C - without counting duplicate names, if column D [cat], A8 [Cat], and only count if; column M has a qty and column N is blank and column O = 00-00-0000, and that column E is not equal to 11ONL
**there is a formula in here at the moment - but it is not counting the unique name keys?
thanks

Solved by O. Q. in 17 mins

I am trying to put formulas in the summary page that count the items on the details page.
For example, Under the “Meals” on the summary page for Monday Beach Club 10/23. My ask is, how many people will be joining us for dinner on Monday night. That information is made up of two columns. First, column Y from the Master Sheet will tell me if they are arriving that day and column E from the Master sheet will tell me how many people will be arriving with each guest. So I would say If there is anything in column Y, then times it by column E and add the total of all of those in F3 on the summary page.

Solved by E. Q. in 19 mins

I am trying to put formulas in the summary page that count the items on the details page in cells F3 to F9
For example, Under the “Meals” on the summary page for Monday Beach Club 10/23 in cell F3. My ask is, how many people will be joining us for dinner on Monday night. That information is made up of two columns. First, column Y from the Master Sheet will tell me if they are arriving that day and column E from the Master sheet will tell me how many people will be arriving with each guest. So I would say If there is anything in column Y, then times it by column E and add the total of all of those in F3 on the summary page.

Solved by G. A. in 14 mins

Column Q: MSKU – String representing a product
Goal: Count number of days a row item in column Q was out of stock between 7/1/17 and 7/31/17 and pull that number into the row corresponding with that item in Column S
Reference Array: The table Columns D:L represents a report in which each row a daily snapshot is given of a SKU in column F, the warehouse code representing the warehouse in which it is in stock in Column H, the quantity within that warehouse in Column I, and the date from which the data was pulled in Column L.
Problem: Because my items may be in stock in multiple warehouses on any given date, it is challenging to create a formula to count the number of different dates in which an item had stock in any warehouse, as one SKU may appear multiple times in the column corresponding to the same date. The reports used to create the table Column D:L do not show line items without stock – They only have information on products that had stock on the dates recorded. So I cannot use a lookup formula to find dates in which stock was zero, because those dates would not be listed in the column.
It will be a challenge but what I am looking for is a formula is column S that, using the line item in column R, will search the Table (Columns D:L) and find the number of dates between 7/1/17 and 7/31/17 in which no data could be found for the the line item in Column R

Solved by K. J. in 18 mins

I want a formula that will count the number of days out of stock for an MSKU (Value in Column E) based on being unable to find a date between the ranges listed in “Table Ranges” (B2:C5) Corresponding with the dates listed in Column M

Solved by K. Y. in 17 mins

HOW TO count separately when age n gender are in a single cell for eg-25 YR/FEMALE in column with some cell also having 23 YR/ F in the same column.

Solved by I. W. in 28 mins

i have 4 sets of charts, "types of denials", "primary insurance", "unit" and "study". Each chart is by count of CPT code. How do I combine all 4 sets of data into one chart? I keep trying to do a combo chart but it looks like junk.

Solved by O. J. in 23 mins

Trying to use countifs function to filter a count through multiple criteria on multiple sheets all in the same workbook. I am using this formula...
=COUNTIFS(CS!E:E,"*=Medina*",Groups!A:A,"*=Medina*",Groups!B:B,"*=Team Brian*",CS!F:F,"*=not*")

Solved by B. J. in 20 mins