I want to get a count of the cells that contain a word, but it has other words in it too, like Yes, depends should count with cells that just have yes.The Yes in the first part should count with the yes by itself but with this formula: =COUNTIF(Raw_Data!$AA$11:$AA$65,”Yes”)
Any ideas I’m stuck on this homework assignment trying to make statistical data look better to right a report on it. Not saying this will do my homework for me, just makes the data easier to read.

I have a record of dates and values.

I would like to use filter function so that when various selections are made, it filters the data accordingly even if sometimes the selection is “All” or just left blank.

I am building a report for sales people and need to connect two data sets with dynamic functions.
Data set 1 is targets, but each individual could have multiple records (e.g. if they have a different leader throughout year. e.g. person a has had 3 leaders. I also need ability to include or exclude records based on selection in the report:

I would like to sum up columns but the columns to be summed up would be different in each row depending on a a cell in that row

I know how to use byrow, choosecols and lambda etc to sum up columns.

I’ve downloaded this Gantt chart project planner from Microsoft. I’m trying to figure out how it works.

I’m looking to increase the number by 25%, but I also need to round up to the nearest multiple of 100, but only if the hundredth is “>800.” If the hundredth is “<800,” round to the nearest multiple of 10.

I’ve got an integer number that I want to split into six different integers so that their proportions match given weights as closely as possible. Example below:

It seemed to be an easy work, but I can’t get it done: