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

I am trying to count cells of a certain background fill color, but all the formulas I have tried either end in error, or a 0

Solved by K. Y. in 26 mins

I need an excel formula that can count the number of times I get paid each month

Solved by E. Y. in 21 mins

Hello
I need to calculate the total amount of cells C1-C7 where the date is 30 days after the date in cell A1.
If todays date is not 30 days after A1, do not count it.
I also need to do the same for 60, 90 and 91+ days.
Can anyone help?

Solved by V. J. in 16 mins

I'm trying to do some data analysis on excel and having some trouble.
So the problem is I need to make the last consecutive number on a list count but the rest needs to deleted to 0. For example, column A has the first number as a single consecutive number "1" therefore column B's equivalent number stands and is converted to column C as "1". But the next numbers in "A" are 1 and 2, the last consecutive number in this case "2" stands and so column B's equivalent is transferred as 0 to column C but the equivalent for "1" is 0 regardless of what is in column B.
Another way of putting this is that if I have in column A 1,2,3 and column B 1,1,1 then column C should have an answer of 0,0,1 as only the last number of a consecutive chain is valid and the others will be converted to 0. So this can be again column A 1,2 and column B 0,0 then column C will be 0,0 because only the last number is taken, coincidentally, this is also 0.
Thanks for your help in advance!

Solved by I. J. in 22 mins

I need help creating a pivot table so it looks like this:
Create a table that counts the number of responses to the question, “Which of the below flavors of ice cream do you like?” Show the flavors on the side, and the gender on top of the table. Hint: you may need to drag/move “Σ Values” to a row or column area in order for this to work. Also, can you change the row values to a custom name? Change the name of each flavor so that it only shows the name of the flavor and not “Count of [flavor name]. For example, change “Count of Chocolate” so it only reads “Chocolate” (Hint: in the Custom Name field in “Value Field Settings”, you must use a space before or after the name of the flavor for this to work).

Solved by Z. F. in 24 mins

My cell has call outcomes within it. The cell includes CALL OUTCOME, EMPLOYEE NAME, BRANCH, MANAGER, LEAD
I am trying to use a COUNTIF formula to count how many surveys were booked per lead. Here is what I am using
=countifs('WPC Emails'!$A:$A,$C$1,'WPC Emails'!$G:$G,"*.O: Survey Booked.*,*Lead: Commercial.*")
However, this formula is only returning results that match the order in which the formula has been typed - ('Survey booked' then Commercial')
I have 7 cells that contain both these trigger words but 'Commercial' is first then 'Survey Booked'.
How do I work the forumla so that it doestn matter which trigger word comes before the other?
I just want the formula to tell me how many cells contain 2 specific phrases.
thanks

Solved by F. J. in 25 mins

I have three different sheets within one Google Sheet. One of those sheets contains a column of dates. I want to use countifs excel. The date must be greater than or equal to a cell on another sheet, and a cell next to them must match text from another sheet. I am attempting to use a countifs formula, however, I am not having any luck.

Solved by K. L. in 12 mins

I have a formula that counts the number of cells meeting my criteria. I would like it to only count the unique cells.

Solved by M. J. in 29 mins

Ok, here's the scenario.
I have a long list of urls in one column. There are some that match (say 20 point to google.com, 10 point to facebook.com, etc.). What I need to achieve is to display in the next column, next to every single url, count of how many times it is present in the list. So the list will go:
google | 20
google | 20
google | 20
facebook | 10
facebook | 10
etc., etc

Solved by F. E. in 19 mins

I have a column in a table with 5 different values and a different column in the same table with either a yes or no value. I want to count the amount of times , one of the 5 values in the first column has a yes value against it in the other column

Solved by K. L. in 29 mins