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

I need one cell to count values in one column and only if the cells next to the values have certain names.

Solved by E. J. in 28 mins

Hello, I am trying to count the numbers of each date in this file.

Solved by Z. Y. in 30 mins

Hi, I have a sheet, with multiple columns of values, I need to count ranges of the blanks between these values in the sheet based on the dynamic criteria

Solved by T. J. in 27 mins

how to auto fill my data count on different tab of the same sheet?

Solved by O. J. in 25 mins

Hi, can you help with these formulas.
Source data comes from Style Status Report TAB to summarise into categories using column A - Open to Buy Tab and column D - Style Status Report TAB. All formulas will need to include this.
Formula 1. COLUMN K8 - can you fix this formula for me?
FORMULA for K8 = sum of column M - W/H Qty but only add if column E is not equal to 11ONL and column N is equal to "blank" or under 4 and if column O is equal to 00-00-0000. The result in K8 should = 385
FORMULA 2 - Column L
This is the same as above - but I need to "count as 1" the Name keys in Column C - that return the value of the formula above in column K. The result in Column N8 = 3
thanks

Solved by O. J. in 15 mins

Hi,
Can you please check formula on Open to Buy -units TAB - F8 [yellow]
Is there a way that this formula can only count "unique" name keys as 1 and ignore duplicate names?
The criteria is correct - it should only count 1 for items with a qty in M - the total is wrong as it is counting 1 for every line with that criteria - not just one for each unique namekey.
thanks

Solved by K. F. in 26 mins

What am I doing wrong?
=IF(COUNT($C$2:C1056)<500,"207",IF(COUNT($C$2:C1056)>=500,"197",IF(COUNT($C$2:C1056)>=1000,"186", "0")))

Solved by T. L. in 12 mins

Hello I am trying to count the number of unique mondays in a data set. I am able to count the number of unique dates or count the number of mondays, but not able to combine the criteria.
The only work around I found was to compare dates (if they are in sequential order) and run a WEEKDAY() formula, but I would prefer one step to do the calculation.

Solved by D. A. in 20 mins

I have been working with Pivot Tables for this data, but I feel that a macro may be better at this point.
Essentially, I have exported an survey that has been attached to an event session. There are three questions for each session and each question has 5 answers to choose from. I would like each question to show a graph like this:
Question: I feel confident that I can apply what I learned.
Session Item: RED
Count of each option:
Definitely Yes!: 4
Definitely No: 2
Sure: 18
No: 0

Solved by O. J. in 14 mins

I wish to count cells that have been coloured, there are 7 different colours being used. I need the total amount of coloured cells, no matter the colour.
Can this be done and how?

Solved by K. Q. in 25 mins